Michael Calabrese <m2calabr(at)yahoo(dot)com> writes:
> If I have a table with a float4 and it has greater
> precision that 4 to the left of the decimal point,
> Access will not let me change that record and gives me
> a write conflict.
You do realize that float4 only carries about six decimal digits of
precision on most machines?
> For example: if I have a table with the following
> Parts:
> PartID Name Price Count
> 555 Tubing 2.50 101.123456
> MS Access seems to get the count from the ODBC driver
> as 101.1234.
And did well to get that, rather than 101.123.
Try float8 or numeric if you want more digits.
regards, tom lane