ExcelBanter - run-time 1004 general odbc

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - run-time 1004 general odbc (https://www.excelbanter.com/excel-discussion-misc-queries/89554-run-time-1004-general-odbc.html)

Rich

run-time 1004 general odbc

I changed the name of MS Access file and then changed it back.

I have a spreadsheet that is extracting data from the DB

I believe I clobbered the links. The code fails on qryTab.refresh

Set wks = Worksheets("Data")
For Each qryTab In wks.QueryTables
qryTab.Refresh
Next qryTab

Can you tell me how to restore the links?

All times are GMT +1. The time now is 12:12 PM.