Batch file ignoring /wrkgrp switch

[Wendy V]

My batch file contains the following:
START "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"C:\Documents and Settings\wvandenberg\My Documents\041336007 Strathmore WWTP
Discharge\8000\8300\041336007StrathmoreWWTD.mdb" /wrkgrp "C:\Documents and
Settings\wvandenberg\My Documents\041336007 Strathmore WWTP
Discharge\8000\8300\StrathDBSecurity.mdw" /user wvandenberg /pwd ****

However, the batch file is ignoring the /wrkgrp switch and will not open the
database. Am I missing something? Some quotes? Different switch order?

TIA,
Wendy

MS Access 2003
Windows XP

 

[Rick Brandt]

My batch file contains the following:
START "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"C:\Documents and Settings\wvandenberg\My Documents\041336007
Strathmore WWTP Discharge\8000\8300\041336007StrathmoreWWTD.mdb"
/wrkgrp "C:\Documents and Settings\wvandenberg\My Documents\041336007
Strathmore WWTP Discharge\8000\8300\StrathDBSecurity.mdw" /user
wvandenberg /pwd ****

However, the batch file is ignoring the /wrkgrp switch and will not
open the database. Am I missing something? Some quotes? Different
switch order?

Ignoring those ridiculously complex paths I see nothing to make it not work.

How are you determining that the workgroup is not being correctly set?

 

[Wendy V]

I know the workgroup isn't being set because I get the message "You do not
have the necessary permissions..." and the db doesn't open. However, if I
remove the START command from the batch file, and leave the rest as is, the
db opens with the correct workgroup but the command window stays open until
either the user closes it or the db.

 

[david]

Looks like the environment isn't big enough to hold the path.
Either increase the environment size or use the short path:
c:\progra~1\micros~1\ and so on.

(david)