Access 97 number data type limits

T

Tony

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?

Thanks

Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 97 number data type limits 1
ODBC link converting Decimal to Long Int 1
Linking ODBC table results in Decimal field size for Number type in Access 2002 1
Number Data Type Unavailable 1
SQL Custom Data Types Not Visible In Access Linked Tables 1
Oracle tables in Access 2002 - Decimal datatype? 0
vinculated table from sqql server200 into access 97, problem with numeric data 0
Format query result as Data Type Number, Field Size Decimal 3

Top