cannot refresh linked access table if source database is locked

G

GregJ

I have recently upgraded to a Windows 7 (64bit) machine and am having trouble
with querying data from an access database.

I have an application which uses an .mdb file. It has the .mdb file locked
while running. I was previously able to refresh a linked table to the
application's .mdb file while it was locked (in Windows XP (x64), Access
2007). I now cannot do this and get a "file already in use" error.

Similarly, I am unable to refresh pivot tables which are sourced from locked
access databases.

Does anyone know how I can remedy this?
 

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

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Project is Unviewable 4
User cannot access linked tables 6
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
refresh linked query 5
Automatically Refresh pivot table 6
Cannot open Access database 1
Missing Relationships 3

Top