Access 97 number data type limits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

I am using ODBC to connect to a third party database (the ODBC driver is 2.51 compliant) and link a table in MS Access 97 SR-2 running on 2000 Pro. The remote data base table has numeric fields of length 15 with 3 decimal places specified (15 digits before the decimal and three after)

When I link to the remote table all of the datatypes for these fields (in MS Access design view) are specified as text and this prevents mathmatical functions

I understand a double has a limit of 15 digits but would the additional three decimal digits tip this over a natural boundary? Does access convert numerics to text if it exceeds 15 digits? Are there any known issues with this

Thank

Ton
 
Probably the simplest and most reliable solution would be to use a later
version of Access. Later versions have a Decimal data type that would meet
your needs.

--
Brendan Reynolds (MVP)

Tony said:
Hi

I am using ODBC to connect to a third party database (the ODBC driver is
2.51 compliant) and link a table in MS Access 97 SR-2 running on 2000 Pro.
The remote data base table has numeric fields of length 15 with 3 decimal
places specified (15 digits before the decimal and three after).
When I link to the remote table all of the datatypes for these fields (in
MS Access design view) are specified as text and this prevents mathmatical
functions.
I understand a double has a limit of 15 digits but would the additional
three decimal digits tip this over a natural boundary? Does access convert
numerics to text if it exceeds 15 digits? Are there any known issues with
this?
 
Back
Top