error 3190

[JimY]

My Access version is 2002. When trying to build a table that has about 180
fields, I can't finish defining data types. Always get error message "Too
many fileds defined". Clicking the "Help" button, it says can't be more than
256 fields. -- Please help.

 

[Allen Browne]

Try compacting the database:
Tools | Database Utilities | Compact/Repair.

While that might solve your immediate issue, this table is not the right way
to build a database. Where you have repeating fields (e.g. Week1, Week2,
...., or perhaps Item1, Item2, ...), you need to create a related table where
these are lots of *records* instead of lots of fields in this table.