Workgroup vs Command Line

[Mike M]

I have a few different Access apps. I have built
shortcuts to each and included the appropriate parameters
to invoke the respective security file.

What I am finding is that if I use the Workgroup
Administrator to join a security file, but then launch the
shortcut for another Access app, the shortcut command
parameters do not override which security file I am
currently attached to. I end up starting the app with the
shortcut, but using the incorrect security file.

Does/should the shortcut command parameters override the
Workgroup Administrator and "join" you to the correct
security file? If so, why does mine not?

Thank you

 

[Joan Wild]

The shortcut switch will use the specified workgroup file for that session.
It does not 'join' you to that workgroup. Using Tools, security, workgroup
administrator, you can join a workgroup. That is the default one that is
used.

But when you use a switch, it doesn't change the default one (i.e. workgroup
administrator will still show the default).

If you are finding that the default one is being used, rather than your
secure mdw, perhaps the shortcut target is wrong.

You need to specify the full path to msaccess.exe or the switch is ignored
i.e.
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"

 

[Br1an_g]

Thanks for that,

i was having problems referencing my mdw file on the
network and your suggestion worked.

i was missing out the full path to MSACCESS.exe

Brian