How To Apply Security on Just ONE Database

[Guest]

How can I make ONE database reuiqre user name and passwod and apply a certain
security?
We have mutliple Access databases in our network. I would like to apply
some security (Read-only for some users, Update/Insert permission for some
users, etc.) to ONE database, say Customer.mdb. I created a workgroup file
and other team members joined the workgroup. Then, all team members were
asked to input user name and password even if they are trying to use other
access databases which do not require any security. How can I prevent this?
How can I make just one database ask user name and password?

 

[Rick Brandt]

How can I make ONE database reuiqre user name and passwod and apply a
certain security?
We have mutliple Access databases in our network. I would like to
apply some security (Read-only for some users, Update/Insert
permission for some users, etc.) to ONE database, say Customer.mdb.
I created a workgroup file and other team members joined the
workgroup. Then, all team members were asked to input user name and
password even if they are trying to use other access databases which
do not require any security. How can I prevent this? How can I make
just one database ask user name and password?

Logging in is driven by the workgroup file, not the MDB being opened. If you
only want to be prompted when opeining a certain file then DON'T join the secure
workgroup. Stay joined to the default and use a shortcut for the secure one
with a target like...

"path to MSAccess.exe" /wrkgrp "path to MDW" "path to MDB"