[AccessD] A97 and confused???

Access may be 'seeing' all the deleted records, they don't go away until you
compact it.

Drew

-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com]
Sent: Tuesday, August 22, 2006 10:14 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A97 and confused???


Drew,

I don't believe its the latest service pack(machine at work)...and I know 
there were records there before...just not sure how many?

Thanks,

Mark


>From: DWUTKA at marlow.com
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] A97 and confused???
>Date: Tue, 22 Aug 2006 09:53:02 -0500
>
>Have there been that many records before, that were deleted?  Also, are you
>using the latest service pack for 97?
>
>Drew
>
>-----Original Message-----
>From: Mark A Matte [mailto:markamatte at hotmail.com]
>Sent: Tuesday, August 22, 2006 9: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


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