Make Table Query and Quickbooks ODBC
Posted on 2008-10-29
I have a simple Make Table query. The query comes from a table in Quickbooks that is linked by QODBC, which is Quickbooks version to link in Access. There is no problems with how Access makes the table. The issue is that the link in really slow. Quickbooks acknowledges this problem. In other words it's a know problem. Fine. However the only way that I know when the transfer is complete is by waiting for Access to allow me to use the program again. In other words it looks like its not responding but really is. After the transfer is complete I can use Access again.
So my question is, after the qryMakeTable is complete, is there some kind of notification that Access can give me telling me the query is done? I know when I'm on vacation someday, the person running this query is going to think there's a problem but there really is not.
Thanks in Advance