[AccessD] A97 and confused???

I found a case (long time ago now - must have A97) where Access reported the
wrong number of records in certain circumstances.  It definitely involved
deletion.

Shamil was helpful in reproducing and confirming my observations, and we
agreed it was an Access bug, though fortunately in an area that the 'user'
shouldn't normally see, as in your case - just temporarily worrying to the
developer.

So don't worry about it!  I did for a while, because it popped up in the
middle of testing some code of mine that involved multiple overlapping
(non-nested) transactions.  Thought you'd like to know.  ;-)

John


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com
Sent: 22 August 2006 16:21
To: accessd at databaseadvisors.com
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com