AutoExec then Quit gives errors in command line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

here's what i have set up:
..bat file - copies a database to a second file
..bat file - opens the copy "db2"
db2 - autoexec macro
macro - runs query
macro - exports data to csv file
macro - exits access program

this all works well if I run the access file from windows, but when I open
the mdb file from a command line, it will run the macro and everything fine,
BUT it gives an error "cannot find file"

i don't understand this because everything works fine, so i shouldn't get
any errors.

here's my files:
inventory.bat:
copy "C:\Program Files\Veeder-Root\Inform\Data\Inform.mdb" "C:\Program
Files\Veeder-Root\Inform\Data\Inform2.mdb"
"C:\Program Files\Veeder-Root\Inform\Data\Inform2.mdb"
exit

AutoExec macro:
run query
quit


any help would be much appriciated. I need this bat file to run every day
behind the scenes, but i don't want this error popping up every day.

Thanks
 
Hi Bryan

In your batch file try running the msaccess executable with your database as
a parameter.

Something like...

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program
Files\Veeder-Root\Inform\Data\Inform2.mdb"


Regards

Andy Hull
 
Back
Top