/wrkgrp switch being ignored

A

Alex

I'm trying to have Access join a specific Workgroup upon startup by using the
/wrkgrp switch, but the switch seems to be getting ignored. I setup a shortcut
where I have the following text specified for the Target in the shortcut:

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /wrkgrp
"\\Cbp200\Databases\Database Mediclassic\Security.mdw"

Unfortunately when I go into Tools/Security in Access, it shows a workgroup in
my local hard drive as the current workgroup, not the one that I specified in
my shortcut. Does anybody know why the specified workgroup is being ignored?
 
A

Alex

I used to have the path to the database in the target also, but when that
didn't work I took it out with the intent of minimizing the number of things
that might be causing the problem. The original version (which also didn't
work) was:

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"\\Cbp200\Databases\Database Mediclassic\Mediclassic.mdb" /wrkgrp
"\\Cbp200\Databases\Database Mediclassic\Security.mdw"



I took out the path to the database as I was trying to simplify the shortcut
with the intent of
 
J

Joan Wild

Alex, your target doesn't need to have the mdb path in it (but likely you'll
want it). The problem you are having is not really a problem at all.

Tools, security, workgroup administrator only tells you the mdw that is set
as your default. That isn't necessarily the one in use. You can confirm
the mdw in use after you use your shortcut by hitting Ctrl-G and typing
?DBEngine.SystemDB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top