Possible side effects between different OS/Access versions?

[Lukashimmelslaeufer]

Hi NG,

I have a major problem with a module of my Access database. At home I use
98SE German version with A2000 on a single machine. Our customer uses 98SE
Dutch version with A2002 where database and data are situated on a network
drive (2000 Server). I have a module running shifting extra working hours to
the next week. So the main tasks are calculating the amount of worked hours
per week and the date where extra hours fit best. I have about 1500 records
per week. Now the problem:

On our customer's system about 5 or 6 records each week are "miscalculated".
Most of the time the date is exactly two weeks too early. On my home system
I checked out the module with about 9000 records without any single error.
Is it possible that the difference in configuration (language version of the
OS, different Access versions or network use) causes these side effects?

Any hint, link etc. appreciated

TIA

lukashimmelslaeufer

 

[TC]

Are you saying that if you reprocess *exactly the same data set*, you get
different results on the two systems?

TC

 

[Dirk Goldgar]

Hi NG,

I have a major problem with a module of my Access database. At home I
use 98SE German version with A2000 on a single machine. Our customer
uses 98SE Dutch version with A2002 where database and data are
situated on a network drive (2000 Server). I have a module running
shifting extra working hours to the next week. So the main tasks are
calculating the amount of worked hours per week and the date where
extra hours fit best. I have about 1500 records per week. Now the
problem:

On our customer's system about 5 or 6 records each week are
"miscalculated". Most of the time the date is exactly two weeks too
early. On my home system I checked out the module with about 9000
records without any single error. Is it possible that the difference
in configuration (language version of the OS, different Access
versions or network use) causes these side effects?

Any hint, link etc. appreciated

That sounds very peculiar indeed. Is the current date a factor in the
calculations? If so, is the system date on the customer's system
correct? Could the regional date/time settings -- the date and time
formats and separators -- be a factor? Are they different between the
two systems?