Making a security password for all users 3

[mlunter]

I used the Access security wizard to set up access permissions for different users. It works fine on my PC - in fact, I have to use the password to login to every Access DB I have to open now.

The DB is stored on a server, and many different PCs will have access to it. When other users open the DB, they are not prompted for a password. I do not understand why. In addition, I would like to not have to enter my password in every Access database - only the one I am speaking about on the server.

Any advice or suggestions would be greatly appreciated.

Thank you,
Mark

 

[PHV]

You have to understand what is a .MDW file.
Seems you haven't defined a specific group file for your database but used your default system.mdw, thus the login prompt for any database for you.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mlunter]

I read up a bit on MDW files, and I see the MDW file that is associated with my DB's. What do I have to do to take the group permissions I already made and apply them to everyone who opens the DB? I'm clicking through the security settings and going nuts trying to figure it out.


Thank you for your help again.

 

[TheTomCat]

I have never actually done this myself but I remember something about when you use the security wizard, it creates a shortcut on your desktop.

I think it has something to do with placing that shortcut on each users desktop.

I rememebr when I was distributing my packaged database, someone told me I would have to include the shortcut with my package in order for the security to be on the users computer.

Good Luck.

Thomas Bailey
a/k/a TomCat

http://www.reportcop.com

 

[KornGeek]

JeremyNYC's website (

http://www.abcdataworks.com)

has some good information on how to implement Access security. Follow it carefully, and it should work. If there is a way to bypass the security, you have made a mistake. Go back to your backup (the one you made before implementing security, right?) and try again. Repeat until it works.

I have implemented this, and if done right, it does work. It's not impossible to crack, but it will protect against casual users.

 

[mlunter]

Thank you gentlemen!