How to Secure an Access Project?

C

CS

I have an Access Project. From what I have read One cannot use the workgroup
file to secure the Program. What is the best way to secure an Access Project?

Thanks in Advance.

CS
 
R

Rick B

What did you read? The workgroup file is the key to securing a database.

Setting up Access User-Level security is not easy the first time. Make lost
of backups and read the following links at least once before you begin. DO
NOT SKIP ANY STEPS. They are ll important.

Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm
 
R

Rick B

Oops - you said "project". My last post may not apply. I have not worked
with "access projects".
 
C

CS

This is what i read under Help:

Note The information in this topic applies only to a Microsoft Access
project (.adp).

Microsoft Jet User-Level security (user-level security: When using
user-level security in an Access database, a database administrator or an
object's owner can grant individual users or groups of users specific
permissions to tables, queries, forms, reports, and macros.) can't be used
with a Microsoft Access project (.adp) (Microsoft Access project: An Access
file that connects to a Microsoft SQL Server database and is used to create
client/server applications. A project file doesn't contain any data or
data-definition-based objects such as tables and views.) file or .ade file.
Users should help protect their copy of the Access project file by using
their computer's file system security, and periodically make a backup copy if
they add their own forms or reports. If their copy of the Access project file
is accidentally or unintentionally altered, users can recopy the file from
their backup copy or from its central location.

Chitra
 
G

Graham R Seach

Use SQL Server security.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
 
N

Norman Yuan

Access project, as you know, is only the front end of SQL Server/MSDE. When
you say "secure an Access Project", do you mean the front end itself, or do
you mean the objects in database (tables, SPs, data...), or do you mean both
front end and database as back end?

For back end objects, contained in SQL Server database, you use the security
means coming with SQL Server. For the Access Project itself, you can make it
*.ade file.
 
A

Arvin Meyer

CS said:
I have an Access Project. From what I have read One cannot use the workgroup
file to secure the Program. What is the best way to secure an Access
Click to expand...
Project?

In addition to Graham's advice to use SQL-Server security, you can create
the front-end as an ADE, which will keep prying eyes out of the object
(forms, reports, code modules) design. You can use a bit of home-grown
security based on the user's Windows login to limit which forms can be
opened, etc. See the following for information on capturing login name,
etc.:

http://www.mvps.org/access/api/api0008.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top