[AccessD] Delete query problem

No relationships are set up. What is annoying is that it was working.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, August 06, 2009 4:29 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Delete query problem

Some sort of relational constraints preventing you from actually deleting some records?

-- 
Stuart

On 6 Aug 2009 at 16:06, Kaup, Chester 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? 
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com