Maximum number of fields allowed in a table

[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

 

[Rick Brandt]

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.

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.

 

[Guest]

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.

 

[John Vinson]

There are reasons for having a large number of
fields (surveys come to mind)

And there are good alternatives even there: Hookum's At Your Survey
shows how to construct a survey with no wide tables.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps