"Too Many Fields Defined" Error when saving table Occasionally, when you have made a large number of design changes to the fields of a table, you may get a "Too Many Fields Defined" error. This is due to the way that Access internally stores the column count for the table, which has a limit of 255. Each time that you change a property for a field, the column count is incremented by 1. Also, whenever you delete a field, the column count isn't decreased, but remains the same. The short term solution is to compact the database, which, amongst other things, will reset the column count to the true number of fields in the table. This error is more normally encountered in databases that haven't been normalized properly, and have in excess of 100 fields. In this case, the real solution would be to redesign the database so that it is normalized as well as it can be. Top   HOME | NEW | TABLES | QUERIES | FORMS | REPORTS | GENERAL | API | DOWNLOADS | TUTORIAL | RESOURCES E-MAIL Copyright & Disclaimer

Last modified at 06/06/2006 15:01:39