Table Locked by other user w/o VBA feedback?

[sgardell]

A few times in the course of development I have
run into a situation where Access believes that
a table is locked by another user. (Manifestly
impossible since I am developing on a detatched
Laptop.) The real issue is that VBA code which
is adding records via DAO reports no errors. I
just don't see any new records added to the table
in question. Added a record manually causes Access
to report the "other user problem." Restarting
Access makes it go away. I would really like to be
able to detect this in code...

Thanks

 

[ClydeDoggie]

No easy answer because there are so many variables in what you are doing. I would suggest finding info on optimistic/pessimistic locking and the different flags you can use to specify the record locking used when you open a recordset, either thru code or bound to a form. ieynaset, Forward Only, etc.