error 3190

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top