Batch running of Access
Posted on 2014-03-19
I have been having a lot of issues getting a windows scheduled process to work properly on a remote server.
The process worked for years. Effectively what it does is update one table in an Access database using a csv file; that table is linked to a Quick Books database table. Then it exports the contents of three Quick Books tables (all linked to MS Access) to csv files.
All this is initiated from a .bat file, with is command:
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "C:\C_LSS\DB\Linked_to_LSS.mdb" /x "LSS_MACR_Mo-1"
I realized today that in using GotoMyPC to access the remote computer, that I have been leaving Access OPEN in that computer overnight when the scheduled process runs.
When I look in the morning, Access is open & it is asking if I want to update a table, etc. Of course, I want all that to run transparently overnight.
Can I be causing issues by leaving Access "open" on the remote machine?