rkroger
asked on
Query Update Runs Automatically
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"But I can assure you that an action query run from the interface will allow you to roll back completely (or accept the partial update, without the records where an error was encountered)."
Marcus ... did you know that in A97 or even A2000 ... there was a bug ... and even with that setting = Yes .. it *Still* performed the Action ! It finally got fixed. That's why I asked which version ...
mx
Marcus ... did you know that in A97 or even A2000 ... there was a bug ... and even with that setting = Yes .. it *Still* performed the Action ! It finally got fixed. That's why I asked which version ...
mx
No, I didn't know that. I guess I was luck never to stumble upon that one! Was it a but in the Access interface only, or also of the entire transaction mechanism?
(°v°)
(°v°)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ah, yes, that makes sense. Imagine another user adding a record to the same table while the first user is pondering whether he/she want to commit the transaction. What auto-number should be used then? Couldn't very well be 101...
(°v°)
(°v°)
How exactly are you running the queries?
mx