Question on lauching access and syntax error during batch file

[Adam Raff]

Hello,

I have a simple question for someone out there that knows access. I would
like to launch access from a batch file and then launch the database in
question. the database and batch file are lactated in the following
directory

C:\ecorr
popss database.mdb
ecorr.bat

My batch file as the following line in it to launch access
C:\"program files\microsoft office\office11\msaccess.exe"

My problem is I can't figure out the syntax for telling access to launch the
above database.

I have tried the following plus a few others:
C:\"program files\microsoft office\office11\msaccess.exe"
database:C:\"ecorr\popss database.mdb"

I get the following error:
The command line you used to start microsoft office access contains an
option that microsoft office access doesn't recognize.

Also is there a way to lauch access by just naming the above database in the
batch file, since the office product may be on another drive while the batch
file will still be on the C drive.

Can any one help with the syntax that I need to use for this to work

Thank You
Adam Raff

 

[Douglas J. Steele]

"C:\program files\microsoft office\office11\msaccess.exe" "C:\ecorr\popss
database.mdb"

 

[Van T. Dinh]

lactated ???

You humanize the computer too much bordering on sexiness ..


<g>
Van T. Dinh
MVP (Access)