Solved Locking Certain Records in Access Table (1 Viewer)

isladogs

MVP / VIP
Local time
Today, 02:16
Joined
Jan 14, 2017
Messages
18,209
I meant a query, sql execute statement or transaction cannot be reversed once it is completed. My fault for not being specific.
However, my point about zero file size increase still applies

FWIW
I was using CurrentDb.Execute...., dbFailOnError in my tests but my point about zero file size increase for boolean updates still applies if using queries.
Of course if the boolean field is being edited on a separate FE, that user will see a Write Conflict message...but that's a separate issue.
 

Users who are viewing this thread

Top Bottom