same password different database

[denise]

When I set up user level security on a test database the
same password applied to Admin user there is also
automatically on a completely different database. Is this
how it works? If I apply passwords on one access database
does it have to be on all access databases? Or am I doing
something wrong? Thanks very much!

 

[Graham Mandeno]

Hi Denise

The password for Admin (and any other users you add) are not specific to the
database, but to the workgroup (.mdw) file. You should use the Workgroup
Administrator or the User-Level Security Wizard to create a new MDW file for
your application, and use the old, vanilla-flavoured one for normal access
to unsecured databases.

It sounds like either (a) you gave Admin a password in the default MDW file,
or (b) you created a new file with the Wizard and it is now your default.

If it's (a), then you have NOT secured your database. Anybody on another
machine will have full access to it without a password. You should remove
the password from Admin and resecure it properly.

If it's (b) then you should run the Workgroup Administrator (Tools menu) and
"Join" the original workgroup file. (It's called SYSTEM.MDW - use Explorer
to find it). Then you should make a shortcut where the target is:
"<path to ms office>msaccess.exe" "<path to your database>"
/wrkgrp:"<path to your mdw file"

For example:
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"C:\My Documents\My App.mdb"
/wrkgrp:"C:\My Documents\My App Security.mdw"