I'm having trouble with a function of the update queries in Access. Specifically, when running an update query, it updates the items from the query even if I select "NO - I do not want to proceed with the update" when the prompt comes up. Normally when you select NO at this point it does not update the items. But for some reason it now runs the updates regardless of whether you have OK'd it by selecting YES - run update or not. The option of not running an update (normal) is critical to the work we do. the databases where I'm having this problems are so far only on two databases that are both located here in the same folder.