too many fields defined message when trying to add columns

[Guest]

I am trying to add additional fields onto a table in either design or
database view, and it comes up with a message saying 'too many fields
defined'. Any idea if I am doing something wrong???

 

[Guest]

Hi Beryl,

Have you compacted your database recently (Tools > Database Utilities >
Compact and repair database)?

Here are some applicable KB articles. The first one likely applies in your
case:

ACC2000: "Too Many Fields Defined" Error Message Saving Table
http://support.microsoft.com/?id=198504

ACC2000: "Too Many Fields" Error When Tables in a Query
Produce More Than 255 Columns
http://support.microsoft.com/?id=248270

ACC2000: "Too Many Fields Defined" Error Message in Update Query
http://support.microsoft.com/?id=199076

Disregard the "ACC2000" in the title of these articles. The information
applies equally well to Access 2002 and 2003.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Vinson]

I am trying to add additional fields onto a table in either design or
database view, and it comes up with a message saying 'too many fields
defined'. Any idea if I am doing something wrong???

You're limited to an (absurdly high, IMHO) 255 fields in a table;
changing the datatype or size of a field "uses up" one of the 255
slots, which can be recovered by using Tools... Database Utilities...
Compact and Repair.

In practice, a 30 field table is pretty wide, and 60 fields is
probably TOO wide. You may want to read up about database
normalization!

John W. Vinson[MVP]