I have a bulk update procedure that runs fine when no one else is editing any records. But, if a record is being edited, my update query just skips it.
Is there any way to lock the table(s) before running my procedure while still allowing it (and only it) to modify the records?
I am not using MS Access security, so everyone is logged in as Admin.
Thanks for your help.