Different output depending on which machine produces it 1

[Zygor]

I have a program on a server. When I run a routine from my machine, the output (in .csv format) has data with decimal amounts. When someone else runs the same rutine from thier machine, the decimal aren't there. The database is not split. The whole program resides on the serever. We are both using Access 2000.

Is there a setting someone knows of that might cause this behavior?

 

[longhair]

Zygor,
does the output have decimal amounts in the csv or in the end program (.xls for example)? it could be how the other user is defining columns if you are importing into another app.
hth
regards,
longhair

 

[Zygor]

Longhair,
Thanks for replying. It depends on who creates the output file. If I do, either one of us can open it in excel and the decimals are there. If the other users does, either of us opens the .csv file and the decimals are not there.

I just noticed that I am on Windows XP and my Access version is Acess 2000 SP3. The other user - Windows 2000 Access 200 SP1. I suspect one of those differences is the culprit.

 

[longhair]

Zygor,
when you produce the file, does the csv have the decimals?
regards,
longhair

 

[Zygor]

When I do, yes.

Another twist. I just tried it on 2 more machines with the same setup as the one that doesn't work. It creates it fine on thiers. Only the one is messing it up.

 

[longhair]

Zygor,
ok - so when you create the csv decimals are there, when the other user does they are not there.
and the user is doing nothing different? pulling the same data set? do you have access to the code that generates these files?
regards,
longhair

 

[Zygor]

DoCmd.TransferText acExportDelim, , "qryCreateCSV", "M:\CommonOutput\NEW.csv", True

 

[Golom]

Have you looked at "Regional Settings / Number" in control panel? It's possible that the decimal settings there are being used and one machine has 0 decimal places while the others have 2 decimal places.

 

[Zygor]

That was it! Thanks!

Have a star for sticking around so long!