[AccessD] Query Puzzler

I'd be curious to know what would happen if you deleted the indexes from the
table and then re-created them.
R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, October 11, 2009 7:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query Puzzler

The SQL couldn't be more straightforward, Rocky. It just says "Delete * From
myTable Where AssessID = 1574". There are 25 matching rows. But since my
original post I've been Googling and Allan Browne suggests that this error
3709 may indicate a corrupt index. I've created a new BE and imported the
data into it. Just checking now to see if that makes the problem go away.
Arthur

On Sun, Oct 11, 2009 at 10:48 AM, Rocky Smolin
<rockysmolin at bchacc.com>wrote:

> Can you post the SQL?
>
> Rocky
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com