Security automatically also for other databases ?

[candice]

I probably have a very stupid question, but I'll ask it
anyway. When I try to secure my data by setting up
passwords and admission rights for users and me (admin.),
somehow all other access databases in the same folder get
the same security (so I need to enter them using a logon
as well, etc..). This is weird, so I must be doing
something wrong ? For all I know, I am doing exactly as
told by the help function...

 

[Lynn Trapp]

No, you didn't do anything "wrong". When you JOIN a secure workgroup
information file (one in which the Admin user's password is not blank) then
you will be prompted for a login every time you open a new session of Access
and open a database. To get around that you need to join the default
system.mdw file using the workgroup administrator and use a shortcut with
the /wrkgrp switch to open your secured databases. The syntax for the target
in your shortcut would be like this:

"FullPathToMSAccess.exe" "FullPathToDatabase.mdb" /wrkgrp
"FullPathToSecureWIF.mdw"