Kbase P128956: MS Access fails with MS Access error 3017 when retrieving information from a table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/01/2009 |
|
Status: Unverified
SYMPTOM(s):
MS Access fails with MS Access error 3017 when retrieving information from a table
MS Access fails when retrieving information from a table with the following MS Access error:
The size of the field is too long
FACT(s) (Environment):
Using MS Access 2003
The error can also be reproduced with MS Access 2007
The table contains decimal columns which have a size greater than 255
The table contains decimal columns which have a SQL-Width greater than 255
The tables were created by using a 4GL procedure or the Data Dictionary
Progress 9.x
OpenEdge 10.x
Windows
DataDirect 4.10 32-Bit Progress SQL92 9.1E
Progress OpenEdge 10.1A driver
Progress OpenEdge 10.1B driver
CAUSE:
MS Access only supports a maximum of 255 for the decimal column size.
FIX:
Decrease the SQL-Width of the column. In order to prevent the decimal columns to be converted to the MS Access text data type, make sure that the SQL-Width is set to a value lower than 28.