Make Table Query and Quickbooks ODBC

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

net
LVL 4
get-ADuser -F ($_.Name -eq "Todd")I.T. ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jmoss111Commented:
Hello netcepter,

How  is the query called?

Regards,

Jim
0
get-ADuser -F ($_.Name -eq "Todd")I.T. ManagerAuthor Commented:
Heres what I have.  A simple query called by a command button.  Also to note it's not a passthrough query because it seems to take just as long.

Command Button is:
Private Sub cmdMakeTableLocal_Click()
On Error GoTo Err_cmdMakeTableLocal_Click

    Dim stDocName As String

    stDocName = "qryMakeTableBacklog"
    DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_cmdMakeTableLocal_Click:
    Exit Sub

Err_cmdMakeTableLocal_Click:
    MsgBox Err.Description
    Resume Exit_cmdMakeTableLocal_Click
   
End Sub

The  Make Table query is:
SELECT qryFullBackLog.* INTO tblBacklogAll
FROM qryFullBackLog;

The qryFullBackLog is basically a combination of linked tables in QuickBooks.

net
0
jmoss111Commented:
After DoCmd.Openquery statement add:

MsgBox ("MakeTablebackLog is complete!")
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jmoss111Commented:
Or you could use:

Dim feedback_msg As String


feedback_msg = "Make table started " & Now()
SysCmd acSysCmdSetStatus, feedback_msg

DoCmd.OpenQuery stDocName, acNormal, acEdit

feedback_msg = "MakeTablebackLog is complete" & Now()
SysCmd acSysCmdSetStatus, feedback_msg
0
get-ADuser -F ($_.Name -eq "Todd")I.T. ManagerAuthor Commented:
Thank you it worked!
0
jmoss111Commented:
you're welcome. have a great day.

Jim
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.