I found this problem with one of my linked excel tables. The value in the table is 1.4707 in excel, but when I look at the table in Access 2010 it show as 1.4706. I don't think this is a rounding issue because the value was entered as 1.4707 and doesn't come from a formula.
This happens whether the table is linked or imported.
Any ideas as to what might cause this and how to fix it?
Thanks,
Luke