"Too many fields defined" error

I’m working on a project using a Microsoft Access database and one of the tables has 157 fields. I can add new records OK, but if I try to edit a record I get an error message “Too many fields defined”. I’ve run the “Compact & Repair” utility in Access to make sure the internal field count in Access is correct and less than 255 but I still get the same error when I run the AspNetMaker project.

Does AspNetMaker have a limit of some kind on the number of fields per table or is this strictly a problem with Access? (I’m running AspNetMaker 7.1).

This is related to MS Access. read:
http://support.microsoft.com/kb/199076

To fix Access database Too Many Fields Defined Error you can try the following manual fixes:

1: Compact Your Database
2: Create A Fresh Copy Of Access Table
3: Pass-Through Query
4: Set Other Field Properties
5: Change A Field’s Data Type

If you haven’t any idea on how to apply these fixes then check this post URL: // accessrepairnrecovery.com/blog/fix-access-too-many-fields-defined-error //