Automation of Access and Quickbooks
Posted on 2011-02-22
We have an Access Database that we have automated with Quickbooks using the QODBC DRIVER. The users have to process data, and it takes several hours. It has grown to the point we need it to start at 3AM after the nightly backups run. Then it will have 4 hours to process before employees arrive so they only have to deal with exceptions.
How can I have it do this:
1) Open Access
2) Open Quickbooks with a specific name and password
I know I can set a timer on the Access main form to start the code, but before the code starts, I need the two apps to open properly.
With the automation, we also use the QODBC driver, which has been a great tool.