/wrkgrp switch won't work

[Guest]

I'm having trouble getting the /wrkgrp switch in my shortcup to work. I've
read numerous threads on this site and think I have a pretty good
understanding of how the syntax in the shortcut is supposed to read. Here is
what mine looks like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp
"G:\SHARED\Value\Database\DatabaseFiles\workgroup\valdb.mdw"
"G:\SHARED\Value\Database\valuations.mdb"

When I click on the shortcut, the database opens fine but the workgroup is
still system.mdw (according to the Workgroup Administrator). My database and
..mdw file are both residing on a shared network. I tried moving them both to
my local hard drive and it still won't work. I have also tried rearranging
the syntax order in the shortcut. My question is this:

- Could there be a network setting/permission that would prevent me from
doing a /wrkgrp switch from a shortcut? I can do a manual switch inside
Access just fine.

- Is there anything that has to be configured in Access to accept a shortcut
command like /wrkgrp?

Any thoughts or insite into this would be GREATLY appreciated. This is
turning into a frusterating matter because my database is complete and the
only thing that is left is securing it properly. Thanks for any help.

Sincerely,

Jed

 

[Keith Wilby]

I'm having trouble getting the /wrkgrp switch in my shortcup to work. I've
read numerous threads on this site and think I have a pretty good
understanding of how the syntax in the shortcut is supposed to read. Here
is
what mine looks like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp
"G:\SHARED\Value\Database\DatabaseFiles\workgroup\valdb.mdw"
"G:\SHARED\Value\Database\valuations.mdb"

When I click on the shortcut, the database opens fine but the workgroup is
still system.mdw (according to the Workgroup Administrator). My database
and
.mdw file are both residing on a shared network. I tried moving them both
to
my local hard drive and it still won't work. I have also tried rearranging
the syntax order in the shortcut. My question is this:

Jed,

The workgroup administrator will not report which workgroup you have joined
using the shortcut switch, it will report which one has been selected by
default. I don't see anything wrong with the syntax in your command line,
what makes you think it's failing?

You should be able to tell if your custom workgroup file has been opened
because it will have an ldb file next to it.

Keith.
www.keithwilby.com

 

[John Welch]

Jed, looks like you have things reversed in your shorcut. It should be:
"path to access.exe" "path to your database" /wrkgrp "path to workgroup"
-John

 

[Guest]

Thanks Keith, you're right...the file is in use. I appreciate your help.

Jed

 

[Joan Wild]

Jed, looks like you have things reversed in your shorcut. It should
be: "path to access.exe" "path to your database" /wrkgrp "path to
workgroup" -John

No in this case, John. The order matters for some switches, but not /wrkgrp

 

[John Welch]

thanks Joan, didn't know that
-John

No in this case, John. The order matters for some switches, but not
/wrkgrp