[AccessD] A97 and confused???

John,

Thanks...I wasn't too concerned...just more curious...and maybe needed a 
little confirmation that I wasn't going insane.

Thanks,

Mark A. Matte


>From: "DJK(John) Robinson" <djkr at msn.com>
>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, 22 Aug 2006 16:49:01 +0100
>
>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
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com