I have a strange problem that I have not come across before. In a multi
user situation I have a readonly query open. When another user tries to
post a change to that record it says it is locked.
How can a readonly query cause Access to lock the record ? I am not even
trying to edit the record.
If I move to another record or close the query, the lock goes away and the
other user can post the changes.
--
Andrew Cutforth
Author of AJC Directory Synchronizer: Directory Compare & Synchronize
www.ajcs.ukgo.com