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

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

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?
 
TonyH said:
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?
Click to expand...

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