Access 97 number data type limits

[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

 

[Brendan Reynolds]

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)

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?