How many fields are possible in an Access Database (Access 2000)?

[Guest]

I get the message that there are too many fields - while I have many fields
what is the upper limit for a single databse as it's not clear how many you
can have?

 

[Rick Brandt]

I get the message that there are too many fields - while I have many fields
what is the upper limit for a single databse as it's not clear how many you
can have?

255 fields or 2000 bytes per record.

Fields that have been deleted or changed will eat into the 255 and you don't get
them back unless you compact the database.

A properly normalized database would rarely have more than 30 fields or so in
any one table. Make sure you are not trying to create a spreadsheet.