Re: lock violations
- From: "[MVP] S.Clark" <steve.clark_NOSPAM@xxxxxxxxxx>
- Date: Thu, 13 Oct 2005 14:48:42 -0400
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" <neeraj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C6383435-DF5B-4B7D-A3F8-4400105D0D7D@xxxxxxxxxxxxxxxx
>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 ?
.
- Prev by Date: Re: Integrating the code for a max.date function with a check box controlling it and
- Next by Date: Re: How to check a text string and then assign a different field a
- Previous by thread: Weekly count
- Next by thread: Re: Problem with adding new records to a table
- Index(es):
Relevant Pages
|
