Update table which is already open

[irade92]

hI
I am trying to update a table with Update Query which is already opened by another Select Query. I get an info that table is already opened exclusively by another user or it is already open through the user interface and cannot be manipulated programmatically.
Any idea how to update it.

 

[apr pillai]

If both queries involves only a single table then it should work.

 

[Minty]

If you are using a Access table try opening the Select query as read only.