'Too Many Fields Defined' error on an UPDATE query when using a Microsoft Access Other file with more than 127 fields

Date:8 December 2005
Product/Release:Visual LANSA V11.0
Abstract:An error will occur when attempting to update a Microsoft Access file that has been loaded into Visual LANSA as an 'OTHER' file and contains more than 127 fields
Submitted By:LANSA Technical Support

Description:

An error will occur when attempting to update a Microsoft Access file that has been loaded into Visual LANSA as an 'OTHER' file and contains more than 127 fields. The error is as follows: "Too many fields are defined" as shown below:

Error Message Screen

There is a limitation in Microsoft Access on the number of fields that can be contained within a table. During an update query, a field for the original value is created and one for the updated value exists as well, ultimately causing two fields to exist during an update. It follows that if there are more than 127 fields MS Access's limit of 255 fields is then reached causing the error mentioned above.