Database Security. Please respond ASAP

[jk12]

Hi all i'm really confused. I have tried to use the user-level security wizard to set my database security which works fine from my computer. However, when someone else logs into the database through my shared area where it is kept, they do not encounter any of my security settings that I set up for them. From this it looks to me that the security settings only apply when someone opens the database directly from my computer and not when they open it over the network from my shared area.

Could someone please explain to me why this is happening and offer a solution to it please. Your help will be greatly appriciated.

 

[statsman]

When you do security in Access, the security settings are saved in a file called System.mdw
System.mdw normally resides in the Windows/system folder.
The System.mdw on my computer is diferent than the System.mdw on your computer. If your database is on my computer and my System.mdw has no Access security settings, it lets me right in with no challenge.
The way to go is to create a new .mdw file (different name) which is in the same folder as the database. You have to place this new .mdw in the path on your shortcut to the database so that anyone who opens the database will have to enter their userid and password.
For an excellent overview of Access security, go to
www.geocities.com/jacksonmacd
download the first file. Its a little long but it gives you an excellent look at Access security.