Single Db Security

[Dion]

How do I set up a database so that a user types in a
username and password only for a single database. I do
not want to create a .mdw file because every Access
database I want to access will require me to login with a
username and password. I only need this 1 database to use
the username and password. Any suggestions would greatly
be appreciated.

 

[Joan Wild]

You need to create a separate mdw file. When you create a new mdw file,
Access just makes it the default one to use.

You can rejoin the standard system.mdw workgroup. For your secure mdb
create a desktop shortcut that points to the secure mdw to use for that
session only. All other Access sessions will use the system.mdw with no
login. The target of the shortcut would look like
"path to msaccess.exe" "path to secure mdw" /wrkgrp "path to secure mdw"