Too Many Fields Defined

  • Thread starter Thread starter Tristanne
  • Start date Start date
T

Tristanne

I am unable to make any changes to my established
database design becaue every time I try to change I get a
too many fields design. I only had 13 line items in the
database, so I deleted them and I still get the error. I
have less that 255 columns which is what the help in
access is telling me. Does anyone have some advice for me
about how to get this errror to go away?
 
every time I try to change I get a
too many fields design. I only had 13 line items in the
database, so I deleted them and I still get the error.
Click to expand...

When you alter a column in a table, Access will create a new column and
delete the old one. The old deleted columns remain and fill up the 255
column limit. You can get rid of them by compacting the database.

Hope that helps


Tim F
 
Back
Top