possible settings problem - data "missing" on one PC, not another!

[Henryp]

This is probably a really stupid question. Two users looking at the same database (linked tables), read-only. One sees all the contents of all the tables. The other has data missing in two fields in one (of many) tables. I say missing - the fields appear to be empty, exporting them produces a blank - but if you sort by either of those fields it comes up with the correct results in the correct order. Another peculiarity - these fields are blank only where the "real" data is a positive number (they are currency fields). Where they have not been completed (they are optional fields) they display "£0.00" without fuss.
There are other currency fields in this same table that display correctly.
My colleague thinks that I'm depriving her of this information deliberately.
We are accessing the same db over a network, in the same way, same OS etc.........

 

[oharab]

I would check your regional settings in the control panel. It could be that they arset up differently and it is confusing Access!

HTH

B ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[Henryp]

Thanks Ben, good thinking.
I did check this, and they are the same. I did also set up Access to ignore regional settings in both cases too...

 

[oharab]

I'm stumped!
Have you tried changing the number format.
Another thing to try would be compacting/repairing the file. Finally I would try moving to another PC and see if that is any better. Access is notorious for finding a weakness in a network!

B ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------