[AccessD] A97 and confused???

Hey Joe,

I got some opinions...I knew if I actually executed the query...or 
compacted...it would be back to normal...and it was...but the consencus was 
that Access just remembers how many rows used to be there...and it got 
confused?

I was just curious if anyone KNEW the answer definitively.

Thanks,

Mark A. Matte


>From: "Joe Hecht" <jmhecht at earthlink.net>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] A97 and confused???
>Date: Tue, 5 Sep 2006 12:55:09 -0700
>
>Mark,
>
>Did you ever get the answer to this?
>
>
>Joe Hecht
>jmhecht at earthlink.net
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Tuesday, August 22, 2006 7:23 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] A97 and confused???
>
>Hello All,
>
>I have a table with 147 rows.  If I open the table...there are no
>filters...only 147 rows.  If I run a MakeTable or an APPEND query based on
>this table I get 147 rows...If I display the datasheet view of "DELETE
>tblPostCardList.* FROM tblPostCardList;"...I get 147 rows...but if I 
>execute
>this exact same SQL...the message is I'm about to delete 3723 rows???  I
>haven't clicked yes...not really too concerned...just repair and
>compact...but very curious if anyone has an understanding/explanation of
>this?
>
>Thanks,
>
>Mark A. Matte
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com