Recent content by Capesy

Re: Delete Query Error - The Table " is already opened exclusively by another user... Actually my set up is a little more complicated than that with a few more necessary variables in the price calculation. The price for each customer is calculated with a discount and the discount is the thing...

Re: Delete Query Error - The Table " is already opened exclusively by another user... I was not aware that you could store the order price as it is based off a calculated field. How do you do that? Currently I am appending the child tables, then the parent table. Then running an update query...

Re: Delete Query Error - The Table " is already opened exclusively by another user... No there is nothing open, everything is closed. And I am archiving to another table because I want to keep a record of the order as it was when it was closed so when the product price changes it does not...

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...