EXACT same query, different results

[Bob Thornton]

I run the EXACT same query on 2 different machines and I get 1 record on machine A and 2 records on machine B. The database resides on a network drive. Any ideas why this is happening?? All help is greatly appreciated!!

 

[Pat Hartman]

Is the back end an Access database? Are you 100% certain that the front ends are linked to the same back end?

 

[Bob Thornton]

Yes, everthing, and I mean everything is exactly the same. I open the database on each machine and run the query, changing none of the criteria and I get different results.

 

[Pat Hartman]

You opened the link table manager or preferably MSysObjects and verified the connection strings? MSysObjects is better because you can always see the entire string which you can't always do in the link table manager window.

You didn't say if the db was Access or something else.

 

[msramu]

same query different results

I've got the same issue with my Access query.

Have verified MSysObjects. Data all resides in Access, with some imported from Excel. Access File resides in server.

Results seem to change within a gap of 1/2 hr...HELP!

 

[Pat Hartman]

Are you positive that no one is relinking the be? Try to find the missing data in the table rather than running the problem query. Is it just one problem query?

 

[msramu]

Are you positive that no one is relinking the be? <-- what do you mean here. In any case, I am the only one working on the file.

Let me give an example of what happens to my data. I have a table of 100 customers. I'm tracking their average $ spent across no of days they have been a customer. Based on that I rank them into categories A, B & C.

When I run the query, customer X in the first try goes into category A, but 1/2 hr later when I run the same query again he could jump to category B. No changes are made to the data or query formula.

Dates are involved in the query, but does that make a difference even if I'm running the query within the same day?

Thanks for your help!

 

[Pat Hartman]

Recordsets are unordered. If relative position in a recordset is a determining factor, you will need to use an order by clause. If you are making use of First() or Last(), they don't work the way you think they do. I think you're going to have to post your query and possibly your db.

 

[JimAhl]

This may be a silly response, but did you check the system dates on the 2 machines. If you are using the current day to calculate your average, maybe one machine has a different date. That would explain the 2 different results.

 

[msramu]

Thanks for that Jim. And yes I did check the time of both machines.

Pat also thank you for your help. I've decided to use a fixed date for my calc. So far it seems fine. But will keep your inputs in mind.