Delete Query Error - The Table " is already opened exclusively by another user...
Hi,
So I have this sales database that I am trying to archive orders in. I have created an append query and and update query to get my desired rows into the archive table but when I try and run the delete query (with everything closed) I get the error: The table is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.
Does anyone have any way of solving the error above or giving me another way to delete the rows in the table?
Thanks!
Hi,
So I have this sales database that I am trying to archive orders in. I have created an append query and and update query to get my desired rows into the archive table but when I try and run the delete query (with everything closed) I get the error: The table is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.
Does anyone have any way of solving the error above or giving me another way to delete the rows in the table?
Thanks!