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

Wendy V wrote:
> 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?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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.

"Rick Brandt" wrote:

> Wendy V wrote:
> > 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?
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>
>
>

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)

"Wendy V" <(E-Mail Removed)> wrote in message
news:F865FA9A-FE6B-4657-AA6E-(E-Mail Removed)...
> 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