Different query results for different users (same dB)?

[stagnate]

I know SQL, and I know databases, but this has me confrused.

I describe it in terms of macros, but I get the same results if I manually execute the queries.

A client has an Access DB that is used by the 5 employees in the office. He has a macro that creates an interim user list, then compares it the the user list from the start of the month.

If he runs the macro to create the interim user list from his computer (computer 1) then any computer can run the other macro and get the differences (about 200 rows).

If any other computer creates the interim user list, then any computer that runs the macro to calculate differences gets invalid results (>3000 rows).

A union of the 'good' interim user list and 'bad' interim user list shows about 3000 rows (out of 4345 rows in each original table), so the macro produces 1345 differenct rows, depending which computer it is on.

I verified that each computer is opening the correct database, and the query is a moderately simple INSERT INTO ... SELECT FROM query.

Does anyone know why this might happen, and/or an easy way to determine which rows are different, and why? It is Access 2003 with SP1, everyone has the same version.

 

[mresann]

Have you checked the links on each front end? If you have a local table with the same name as a back end table, you will query the data on the local table. You can tell if a table is linked by the presence of an arrow in front of the table.