What are Lock Violations?

[David Gartrell]

Hi there,

I have an Access 2000 database which which has one particular update query
which, from time to time gives me problems. It can come up with a message
saying that it can't update all the records in the query due to x number of
lock violations - but it doesn't do it all the time.

I've tried looking on Access's help system but it has nothing about lock
violations at all. Could anyone tell me what they are and why I might get
them?

Thanks for Reading

David

P.S. To reply to my email address ppplease remove the ddduplication fffirst!

 

[Guest]

Normally you get a lock violation if the record is being accessed elsewhere -
is ther another user with the table already open?

Sheila