Re: Record Count Inconsistent
From: Jay (anonymous_at_discussions.microsoft.com)
Date: 05/11/04
- Next message: Marc: "Re: Updating all records in a recordset"
- Previous message: Jim Carlock: "Re: merge multiple databases"
- In reply to: George Nicholson: "Re: Record Count Inconsistent"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 May 2004 16:28:24 -0700
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
>-----Original Message-----
>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
>
- Next message: Marc: "Re: Updating all records in a recordset"
- Previous message: Jim Carlock: "Re: merge multiple databases"
- In reply to: George Nicholson: "Re: Record Count Inconsistent"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
