security applied to all my DBs

[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

 

[Joan Wild]

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"

 

[shanej]

What is the /wkgrp? Is that my workgroup or domain? ie "/myworkgroup"

 

[shanej]

Nevermind, I got it. Thanks!

What is the /wkgrp? Is that my workgroup or domain? ie "/myworkgroup"

 

[kincaidch]

I was having the same problem. Thank you so for posting this! I worked great!