Re: Float Percision with MS Access 97

Michael Calabrese <m2calabr@yahoo.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