Kbase P146235: Microsoft Access Error: The size of a field is too long. running a query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/14/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL: "The size of a field is too long." running a query in Microsoft Access.
DBTool was used to adjust and save the SQL width of the fields involved.
Some CHARACTER fields are more than 300 characters long.
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
This is a Microsoft Access limitation can not handle character fields that exceed 254 characters.
FIX:
There are few possible solutions for this issue:
1. Use another ODBC or JDBC client to access the data from the Progress database table whose fields lengths exceed 254 characters.
2. Create an abridged version of the table with the same data as the original table and the fields are restricted to the 254 character Microsoft Access limit.
3. Create an SQL View to hold a truncated version of the table where a maximum of 254 characters are stored in any CHARACTER field and use Microsoft Access with that SQL View instead of the table.