Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running an Access process from a batch file

Status
Not open for further replies.

mrfritz44

MIS
Nov 21, 2003
75
US
I'm on what I hope is my last step for this project. I need to run my database X.mbd from a .bat file. This Access process creates a file that the next command in the .bat file uses. Here are my commands:

APC.mdb
oce.exe -i C:\Progra~1\OCEAPC~1\M.txt -o C:\Progra~1\OCEAPC~1\MOutput.txt
@start Oce.log

What happens with this however, is that I get an error message that says: "There was a problem sending a command to the program." Any ideas?
 
OK, so that error was caused by my macro command to Quit. I removed that command in the macro and now it runs fine EXCEPT...................how can I close X.mdb after the process has run from the batch file?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top