Error 3190 "Too Many Fields Defined"

[rajumca]

I am using ACCESS 97 at work place. And i need to add some columns to the database.

When i add columns to the empty database which is having 0 rows, i am able to add columns to the table.But i

am not able to add columns to the table which is having around 260 rows and database size is 2900 KB only.

I am wondering why access database is not allowing to add columns if there is some data in the table.

Currently the table is having only 236 columns and i am trying to add 5 columns but it is throwing the error

3190. And as mentioned earlier, if table is empty i am able to columns.

Any help can be appreciated.

 

[Golom]

The limit is (# of Fields + # of Indexes) may not exceed 255.

It should not matter if the table is empty or contains data (i.e. it has rows).

 

[PHV]

Anyway I wonder why so many columns in a single table ...
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

only 236 columns" IMHO 36 is too many.

Duane
Hook'D on Access
MS Access MVP

 

[Golom]

What PHV and dhookom are saying is that the definition of a normalized table is that each non-key field should be an attribute of the key, the whole key and nothing but the key.

It is rare that any real-world entities (i.e. Keys) have over 200 attributes that you need to track so our assumption is that you have a severly un-normalized table and that will cause problems with retrieving and manipulating data down the road.