Record Count Inconsistent

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

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
 
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,
 
Yes, sure they are the same file. I watched the .ldb
show up when the file was accessed from the client end.
Did this for each of the 4 clients.

In addition, I watched the Shared Folders/Files (under
Computer Management MMC) show the connections and users
as the MDB was accessed.

The same query ("select * from QryReport) is run from all
4 machines. I don't see how the actual query in
QryReport could be different if accessed from a different
machine. But then again, I didn't closely scrutinise the
query.

I forgot to mention that the query is being run in a 3rd
party query utility (SQL Conn something) via an ODBC
System DSN. I did verify that the DSN points to the
correct file. The file is accessed via a mapped drive,
no UNCs.

Thanks for commenting,
J
 
Back
Top