Can not open other Access DBs if joining security workgroup file

[Guest]

Hi,
I created Security workgroup on Access DB I developed recently. Then I went
to every user PC and joined to the security file in order to login.

But, from now on, every user when open any other database, it won't open
unless he re-join the default security file.

Would someone advice how to handle this situation?

Thanks,

 

[Rick Brandt]

Hi,
I created Security workgroup on Access DB I developed recently. Then I went
to every user PC and joined to the security file in order to login.

But, from now on, every user when open any other database, it won't open
unless he re-join the default security file.

Would someone advice how to handle this situation?

Something doesn't sound right. While it is required to use a specific mdw to
open a secured mdb ANY mdw should open a non-secure one. That is because a
non-secure mdb grants full permission to the default user group "Users" and
every account of every mdw ever made is a member of "Users". In fact, you can;t
create an account that is NOT a member of Users even if you wanted to.

Now if what your concerned about is that they always have to "log in" no matter
which file they are using that is exactly because you made their default mdw
file one that requires a login. If you don't want that behavior then change
their default workgroup back to System.MDW and create a shortcut for your
secured app that specifies a different mdw file as a command line argument.

 

[T. W.]

I have the problem you just specified in your explanation.

I assume when you say the command line argument, this is something I can put
in the shortcut itself; so my two questions would be:

1) How do I make Access 2003 default and stay defaulted to the System.mdw.

2) How do I write (or what do I write) in the shortcut to cause Access to
use the MDW I created and the DB associated with it?

 

[Joan Wild]

1) How do I make Access 2003 default and stay defaulted to the
System.mdw.

Open Access, and go to Tools, Security, Workgroup Administrator. Join the
standard system.mdw workgroup - that will now be your default.

2) How do I write (or what do I write) in the shortcut to cause
Access to use the MDW I created and the DB associated with it?

The target would be something like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"