[AccessD] A97 and confused???

Joe Hecht jmhecht at earthlink.net
Tue Sep 5 14:55:09 CDT 2006


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




More information about the AccessD mailing list