Too Many Fields Defined

[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?

 

[Tim Ferguson]

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.

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