[AccessD] Delete query problem

Post the SQL.







On Thu, Aug 6, 2009 at 2:06 PM, Kaup, Chester <Chester_Kaup at kindermorgan.com
> wrote:

> I have a simple delete query. When I open the query in design mode and
> click on view it shows 69 records that will be deleted. This is the correct
> number. When I run the query it only wants to delete 29 records. A compact
> and repair and restart did nothing. I have never seen this before. Your
> ideas?
>
>
> Chester Kaup
>
> Engineering Technician
>
> Kinder Morgan CO2 Company, LLP
>
> Office (432) 688-3797
>
> FAX (432) 688-3799
>
>
>
>
>
> No trees were killed in the sending of this message. However a large number
> of electrons were terribly inconvenienced.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>