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...ent/secfaq.asp

smrenga