Linking ODBC table results in Decimal field size for Number type in Access 2002

  • Thread starter Thread starter Patrick Jackman
  • Start date Start date
P

Patrick Jackman

Sorry for the cross post to odbcclientsvr, this looks like a better group.

I am using a DataDirect ODBC driver to link Clipper tables to an Access 2002
application. The linker selects a Decimal field size for Number data types.

Prior to upgrading to Access 2002 we used Access 97 and when linking via the
same driver the field size for Number types was set to Double by default.

Since upgrading we are getting the error "Scaling of decimal value resulted
in data truncation" when performing simple SQL operations such as "SELECT
FIELD1, SUM(FIELD2) AS SUMOFFIELD2 FROM TABLE GROUP BY FIELD1". These errors
did not occur under Access 97 with the field size set to Double.

Is there some way to instruct the linker that a Double field size should be
used for Number data types?

Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Jackman
Microsoft Access Developer since 1994
Vancouver, BC
604-874-5774
 
Our resolution to this issue:

1. Create a new empty Access 97 container.
2. Use the Access 97 Linking Wizard to create ODBC links to the Clipper
tables.
3. Convert the Access 97 database to Access 2002.
4. Import the Jet tables from the existing Access 2002 database.
5. Re-establish all security settings and database properties for the new
database.

Do not relink the ODBC tables with the Access 2002 Linking Wizard or a
functional double data size will be replaced with a decimal data size of 10
/ 2 in cases where it should be 11 / 2 resulting in the error "Scaling of
decimal value resulted in data truncation" when performing SQL operations
with the DataDirect 4.1 dBase driver.

This problem also exists with the Access 2003 Linking Wizard.

Patrick.


Sorry for the cross post to odbcclientsvr, this looks like a better group.

I am using a DataDirect ODBC driver to link Clipper tables to an Access 2002
application. The linker selects a Decimal field size for Number data types.

Prior to upgrading to Access 2002 we used Access 97 and when linking via the
same driver the field size for Number types was set to Double by default.

Since upgrading we are getting the error "Scaling of decimal value resulted
in data truncation" when performing simple SQL operations such as "SELECT
FIELD1, SUM(FIELD2) AS SUMOFFIELD2 FROM TABLE GROUP BY FIELD1". These errors
did not occur under Access 97 with the field size set to Double.

Is there some way to instruct the linker that a Double field size should be
used for Number data types?

Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Jackman
Microsoft Access Developer since 1994
Vancouver, BC
604-874-5774
 
Back
Top