General ODBC Error on QueryTable.Refresh - potential causes?

[JKFEagle]

This is probably a real generic problem with about a thousand possible causes but I'm going to ask anyway. I have an Excel file with code that generates the following error:

General ODBC error

The line of code that is generating the error is:

Selection.QueryTable.Refresh BackgroundQuery:=False

Now, I did not write the code and I know at one time it did work. I was hoping someone could help me out so I can zero in on the problem without having to trace out the entire code logic. What typically would give this error? Thanks in advance to all.

 

[TommyGun]

Re: General ODBC Error on QueryTable.Refresh - potential cau

Well, like you said, there could be many causes to this error. It could be related to invalid SQL syntax, an inability to connect to the table/database, or the table/database could've been changed and fields in the SQL no longer exist, and this is just a few.

Please post some of the "border" code around this line that is causing the error.

 

[JKFEagle]

Re: General ODBC Error on QueryTable.Refresh - potential cau

Here is the code around the error. What is interesting is that every time it tries to do the Selection.QueryTable.Refresh it crashes and gives the ODBC error regardless of which section it is. Below is a section with two of those lines. Thanks for any help you can give.


Macro UPDATES THE STOCK DETAIL INFO
Sheets("STOCK").Select
Range("A3").Select
Selection.QueryTable.REFRESH BackgroundQuery:=False
' MACRO UPDATES FILL RATE DATA
Sheets("FILL_RATE").Select
Range("A3").Select
Selection.QueryTable.REFRESH BackgroundQuery:=False

 

[JKFEagle]

Re: General ODBC Error on QueryTable.Refresh - potential cau

OK yet another bit of info that could be helpful. The refresh commands prior to that one seem to work (different worksheets).