Redesign: error message

  • Thread starter Thread starter Zircon
  • Start date Start date
Z

Zircon

Guest
I have expanded our medical research database and now I cannot open the data entry form. I am getting the error message "too many fields defined." Any words of wisdom would be appreciated.
 
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.
 

Users who are viewing this thread

Back
Top Bottom