Database security

[sundarv]

hi
Any one knows how to secure an access database. I'm working in a product development. i need to prevent the user from viewing the database.

Any help would be appreciated

thanx in advance
sundar

[paulw]

Check out the Security menu item under Tools.

You need to set the password for the Admin account to enable the login feature (by default you login as Admin with a blank password) Admin has full rights to everything.

You can set up groups and then add users to the groups. Rights can be set for each report, query, table etc. and you can set default rights.

It is much easier to set this up BEFORE you start.

Check out the help topic on Security.

Cheers,

Paul.

[smrenga]

Hi!

1. Create a new user

2. Change the new user as the Administrator(add Administrator group to this user) and remove 'Admin' user from the Administrator group. This ensures that, the new user is the administrator.

2. Create a new copy of system.mdw using Wrkgadm.exe

3. Now, open your database with the new user and new system.mdw file

U can do this by
a. creating a shortcut to your database in the desktop.
b. Right click the icon and open Properties window
c. Type the following in the provided text box
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" "Test.mdb" /user "TestUser"
/systemdb "c:\test\system.mdw"

4. Assign a password to the new user & Run the security Wizard. This will give a new secured database apart from your original.

Finally, the secured database can be opened only by the new user created along with the newly created system.mdw file.


Hope this procedure is not confusing.

Else go this link, for clear information
http://support.microsoft.com/support/access/content/secfaq.asp

smrenga