Hi! Is there anyone out there how can tell me how record lockting with DAO works. REWARD: 1 beer ca

[Daren Chandisingh]

Whether locking is pessimistic or not, DAO locks the 2Kb page that contains your record. Pessimistic locking only determines when the locking occurs (on Edit() if pessimistic, else on Update()).

If a particular page is locked, no other user can edit any records in that page, even if they are not the same record as the one being edited.



--
Daren Chandisingh