Password for Databases

[Jeff Robinson]

Someone put a database on my pc which prompts you for a
password, however, now everytime I open any database I get
prompted for that same password. This is really annoying
because none of my other databases required a password
prior to this database. Is there any way for just the one
database to require a password, but not the others that
never had one?

Thanks,
Jeff Robinson

 

[Bob Gardner]

It sounds like you joined a workgroup. To avoid typing
your username and password each time you open the database
you can add it to the shortcut that launches the database
application. At the end of the path include /USER
YourName /PWD YourPassword

 

[Joan Wild]

Provided they set up security properly, you should have a separate workgroup
file (mdw) for the secure database.

You would rejoin the default system.mdw workgroup file, which should not
prompt you for a login. Run the workgroup administrator (Tools, Security
menu) and join system.mdw - it usually is in the windows system folder.

For the one database that is secured, create a desktop shortcut that points
to the workgroup file to use for that session (this won't affect other
databases that will use the system.mdw workgroup, as it is your default).
The shortcut target would look like:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"