Lock Violations

[Guest]

Hi

I have created an update query, but it won't update around half of the
records due to 'lock violations'. What could be possible causes of this?

Thanks
Daniel

 

[Arvin Meyer [MVP]]

Usually, locking violations occur because someone has the tables open. When
I see that as a possibility for the interruption of large data sets, I
usually suggest that the records be updated at the end of the day when no
one is in the database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Sorry I should have said I tried entering it when no-one else was in it, but
it made no difference.

Any ideas otherwise?

 

[Guest]

Other ideas:

1. You have a corruption problem.

2. No one may be one; however, the ldb file might not be updating properly.
Get everyone off of the database including yourself; delete the ldb file;
restart the database.

3. You have something else going one at the same time. Make sure that all
other queries, forms, and reports are closed. Check for hidden objects.

4. Your update query is rather complex or doing things like a self-join.
Please post the SQL.

 

[Arvin Meyer [MVP]]

You could be locking your app yourself by trying to connect to the same
record(s) with 2 different forms.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access