security applied to all my DBs

  • Thread starter Thread starter shanej2015
  • Start date Start date
S

shanej2015

I setup security groups and users for a particular DB, now when I open
any DB it requires that I login. I did not intend for that, and it will
be a problem for other users with limited privileges. How can I use
security for just a single DB rather than all DBs?

Shane
 
Hopefully you didn't set these up in your system.mdw workgroup; the first
step is to create a new workgroup file.

Anyway, the solution is to use the workgroup administrator to rejoin the
system.mdw as your default.

Access will use this mdw for all sessions of Access (no login).

For your secure mdb, you can rejoin your secure mdw using the administrator
(tedious), or create a desktop shortcut that points to your secure mdw.
Using the shortcut will override the default for just that session. The
target of the shortcut would have the following in it:

"Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
 
Back
Top