Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Tables: "Too many fields defined" error message

Author(s)
Dev Ashish

(Q)    When I try to save a table, I keep getting the error message "Too many fields defined". What's causing this to come up?

(A)    Access keeps an internal count of total number of fields in a table and has a limit of 255 fields per table. Each time you modify a field or add a field, this count increases by 1. When you delete a field, Access does NOT reset this counter. So it's possible for you to have less than 255 fields and still get this error message.

    If your field count is less than 255, just compact the database again which should reset the internal field count counter.


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer