Question:
I receive the following error message when trying to save
changes I made to database:
-
-
Answer:
The Microsoft Jet database engine has an internal limit of 255 fields
per query. As the Microsoft Jet database engine iterates through the
records in an update query, it creates a field for the original value
and a field for the updated value. When more than 127 fields are
selected, it reaches the 255 field limit of a query.
Don't put more than 127 fields on Add/Edit pages.
For additional information about this error, please refer to the
following Microsoft Knowledge Base article: 'Too
Many Fields Defined' Error Message in Update Query.
|
