Link to home
Start Free TrialLog in
Avatar of rkroger
rkrogerFlag for United States of America

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.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Which version of Access?

How exactly are you running the queries?

mx
ASKER CERTIFIED SOLUTION
Avatar of harfang
harfang
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"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
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°)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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°)