Setting up security on a shared database.

[lgraham]

Hi,
I've set up security (user groups/names/passwords) in Access 2003 while in
exclusive mode on a database located on a shared drive. I switched the
database back to shared mode, tested all the new user accounts from my
computer, and everything worked fine. However when I asked the users to open
the database from their computers there was no prompt for a password and they
seemed to have full rights.
What can I do to fix this?

Lindsay

 

[Olduke]

You should never enter the dark and murky waters of Access Security without a
guide.
It sounds like you did not create a special .mdw file when you installed
your security.
Security settings are saved by default in your System.mdw file. It normally
resides in Windows/System on your C drive.
The System.mdw file is different on every computer...why? My computer has
different software, different settings even a different wallpaper than yours.
As a result, my System.mdw file is different that yours. If you put your
secured database on my computer, and there is no security set in my
System.mdw, it lets me right in.

Your security settings should be saved to a new .mdw file (do not name it
system) which is in the same folder as your back end. The shortcut you
create should include this file in its path.
Don't forget to return the settings to System.mdw when the user logs off.

 

[Olduke]

For an excellent overview of Access security, go to:
http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald. It’s a little
long but it tells you everything you need to know.

 

[Paul S]

Access Security Instructional Document
http://www.box.net/shared/45f1w0o4kw

 

[lgraham]

Thank you!

For an excellent overview of Access security, go to:
http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald. It’s a little
long but it tells you everything you need to know.

 

[Olduke]

I prefer the one by Jack Macdonald.
Written by a genius to be used by idiots.

 

[TinMan]

Hi there i am looking at the same problems can you link me to this doc as
this link is no longer available. Many thanx