Hi,
I have an Excel workbook that has two tables on separate worksheets.
They are connected to two queries in an Access database.
I created them via the DATA > GET EXTERNAL DATA > FROM ACCESS menu.
When I open the workbook I can refresh one, but when I try the other one it says:
The strange thing is, if I close the workbook and reopen it, I can refresh that one but not the first one!The query did not run, or the database could not be opened.
I am thinking perhaps it is not closing the connection after it refreshes?
Bookmarks