Re: Record Count Inconsistent

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: George Nicholson (JunkGeorgeN_at_msn.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 17:11:52 -0500

Are you sure they are referencing the same data file? (Is the 4th user
pointing to a copy on their local machine? The lower record count suggests
that as a distinct possibility).

Does qryReport use some sort of local setting that might differ between
machines? (i.e., if record counts of tables match but queries return
different results then check to see how the queries differ).

HTH, 

-- 
George Nicholson
Remove 'Junk' from return address.
"Jay" <anonymous@discussions.microsoft.com> wrote in message
news:b78701c43780$d3b6a340$a301280a@phx.gbl...
>
> Hi,
>
> I have a client who is experiencing a bizarre problem.
>
> She has an Access 2000 MDB, which is shared on a server.
>
> From 3 machines, the query:
>
>   "select * from QryReport"
>
> lists 3624 records.
>
> From another machine, the query returns only 3462
> records.
>
> Component Checker returns MDAC 2.7 RTM on all machines.
> All machines are Win2K.
>
> Why would one machine return a different result set
> almost 200 records less?  At this point, I do not know
> what Jet Engine SP is installed (my next step to
> check)...could that be a cause anyway?
>
> Thanks a ton.
> Jay
>

Relevant Pages