Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update query

Status
Not open for further replies.

knighty03

Technical User
Aug 12, 2003
32
GB
I am running an update query and i keep getting an error message saying 'the table TBLE_compositions_copy is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.' I am the only person with the database so no-one can be using it. Any help would be great.
 
Have you got the table opened? Are you running this query from within access?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top