Access 2010 Automation
Posted on 2011-09-28
I want to automatically start up Access and run a sub procedure. The Access database runs an update process to a PLSQL database. Right now, I have to open the database, click a button, and wait for the process to complete. I'd rather be able to schedule a script that opens the database, clicks the button, and closes the database when the process is complete.
I attempted to write a batch file that will do this. Here's what I tried:
start msaccess.exe /ro "\\PathToAccessDB\UpdateDB.accdb" /x cmdUpdate_Click
The database starts up, but the problem is that the /x option expects a macro, not a subprocedure.