Maximum number of fields allowed in a table

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

Guest

Hi

I am setting up a new database with relationship tables and am having a
problem with one particulaly large table, I am getting an error when saving,
the table has 120 fields within it.
does anyone know the maximum number of fields allowed in a table.

thanks

fish
 
fish said:
Hi

I am setting up a new database with relationship tables and am having a
problem with one particulaly large table, I am getting an error when saving,
the table has 120 fields within it.
does anyone know the maximum number of fields allowed in a table.
Click to expand...

255, but there is also a maximum number of bytes per row which you can hit
well before the 255 field maximum.

Anything more than 50 or so fields almost universally suggests an incorrect
data structure though.

Do you really have one entity with 120 attributes? I seriously doubt it.
If you describe your data structure I'm sure you will get lots of advice on
how to restructure it.
 
Maximum is 255, I think, but if you have deleted lots of fields the database
could still think they're there. Click Tools > Database Utilities > Compact
and Repair.
This could help with the immediate problem, but you should make sure you are
not constructing a monster. There are reasons for having a large number of
fields (surveys come to mind), but it would probably be worth taking a close
look at your database structure.
 
Back
Top