ODBC link to Foxpro problem

[Peter Bellamy]

Sometime ago I wrote a report that was based on a linked table in a Foxpro database. Briefly the code does the following:
Makes a new table of the linked table locally, using just the columns required.
Generates a report built on this new table with Count and Sum of values for the final page

After upgrading a users PC I did a check to ensure the Access program still worked, it did but produced a different 'Total Value' result on the new PC !
I tried in on an unchanged PC and it gave yet another result.
The row Count figure remained the same but the Total Value was different.

I have subsequently altered the code so it creates 3 local tables, one after another from a loop. Doing the Sum of Value on these tables they all produce different results, but again the row Count are all the same!

I have made sure that the source Foxpro dB is not being changed whilst testing.

I am not very clued up on ODBC, I am still teaching myself Access.
Has anyone got any ideas?

Cheers

 

[SOS]

Do each user have the same EXACT version of Access INCLUDING Service Packs?

 

[Peter Bellamy]

Thanks for your reply.

I have subsequently altered the code so it creates 3 local tables, one after another from a loop. Doing the Sum of Value on these tables they all produce different results, but again the row Count are all the same!

This is happening for one user, consequtive SELECT INTO statements ??

 

[SOS]

Thanks for your reply.



This is happening for one user, consequtive SELECT INTO statements ??

Sorry, I guess I didn't ask it the right way...

Does each user have the same exact version of Access INCLUDING SERVICE PACKS? This is an important question to answer and find out FOR SURE - so be sure to compare them all as there could be one with an unresolved bug which isn't affecting the others. That could cause the results to be out of synch with each other.