Refresh data with open database


Nan Hauser

I have an Excel 2007 datasheet that is linked to an Access 2007 query. When
I try to refresh the data in Excel when the database is open, I get an error
message telling me "You attempted to open a database that is already open.
Try again when the database is available." I have to close the database to
update the data. Is there a way to refresh the data when the database is


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question