Too many fields

[Manny]

Currently the office uses Access 2000.

While creating a new database, I went to add a field to a table and I've
apparently hit the limit. I created a second table to store the extra data.
I deleted a field to create an autonumber primary key field so I can link
them. But now, no matter how many fields I delete on the first table I still
receive the too many fields error when trying to save. The fields are linked
to a form and a report, could that be the cause of my problems?

 

[George Nicholson]

Do a Compact & Repair

Access has a 255 field limit per table. When you delete a field, it
continues to take up space and still counts against that limit until a
Compact is done.

HTH,

 

[Arvin Meyer [MVP]]

A well designed database practically never requires more than 50 fields. I
don't think that I've ever written one that required over 30 or so.

You must have fields like Address1 Address2 Address3, etc and that is not
relational, nor efficient in design. Think long, not wide.

 

[van de Winckel Ivo]

Currently the office uses Access 2000.

While creating a new database, I went to add a field to a table and I've
apparently hit the limit. I created a second table to store the extra
data.
I deleted a field to create an autonumber primary key field so I can link
them. But now, no matter how many fields I delete on the first table I
still
receive the too many fields error when trying to save. The fields are
linked
to a form and a report, could that be the cause of my problems?