By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Readonly query holding record lock

P: n/a
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.ajcsoft.com
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.