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 query did not run, or the database could not be opened.
The strange thing is, if I close the workbook and reopen it, I can refresh that one but not the first one!

I am thinking perhaps it is not closing the connection after it refreshes?