Access dataquery in Excel sheet locks Db while workbook is open

[TomPC]

Hello Fellow Exceleers!

Using XP/Access 2007/Excel 2007

I have a sheet with a data query that brings in an Access table. It is refreshed in a macro as follows:

Sub UpdateRefData()
    Sheets("RefData").Range("A1").ListObject.QueryTable.Refresh BackgroundQuery:=False
End Sub

The problem is - while one user has that sheet open - not actively refreshing - just open, the database locks. The database has other tables that people need to update in parallel.

Has anyone else experienced this? Is there additional code I ought to have used to close the connection or is this the way it rolls?

Thanks

Tom

 

[TomPC]

I should add... by 'data query', I mean:

Data > [Get External Data] From Access > (Select Db.mdb) > (Select Table) > Import as Table into Existing Worksheet Cell A1.

Properties/Usage:
Enable background refresh TICKED
Refresh every x minutes NOT TICKED
Refresh data when opening the file NOT TICKED