lock violations

[neeraj]

I ran a delete query in which 3726 records were selected from a table say
Tb1. In this query, Tb1 was inner joined to a select query say Query1 which
in turn was outer joined to another query say Query2
so the design looked like
Tb1----Query1---->Query2
While running the query, it first said that 3726 records would be deleted
and then popped a message saying "MS Access cannot delete 0 records in the
delete query due to key violations and 185 records due to lock violations". I
said a yes and
eventually the table Tb1 had 3726-185 = 3541 records deleted only. I dont
know what these 185 records were yet but what could be the cause of this
message ?

 

[[MVP] S.Clark]

Could those records be locked by another user or process?
If not, could the inner join cause a higher number of records to be
displayed than the reality?

Steve Clark, Access MVP
http://www.fmsinc.com/consulting

 

[neeraj]

I tried running the same delete query today on a copy of the original table
Tb1 today and it didn't give the 'lock violations' message. But it selected
only 3541 records and deleted 3541 records. I tried this a few times on
copies of Tb1 with the same results. I still dont know what caused it to give
the violations message yesterday, I am the only user so that couldn't be the
reason. Query1 and Query2 both use Tb1