asked on

Automation of Access and Quickbooks

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.

Thanks!

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott McDaniel (EE MVE )

I don't use QODBC (I manipulate QB directly through the SDK), but you should be able to detect when the connection is opened. QODBC is nothing more than a wrapper around the SDK, so there should be logic built into the product to insure that QB is opened before running code. Have you found this to NOT be the case? That is, have you found that the QODBC connection is failing to open properly, and your code is not being run?

As an aside: What in the world are you doing that takes 4 hours to perform in QB :) ? The SDK is slow, but it's not that slow ...

ASKER CERTIFIED SOLUTION

Armen Stein - Microsoft Access MVP since 2006

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sharpapproach

ASKER

Ended up using a Windows Scheduler for the time and the SDK to pass parameters.

Thanks!