What is max. number of fields in access 2003 table?

B

Bamafan

I know in the past it has been 256 fields but if it has been increased then
that would solve a problem I am working on now. I have one table linked to
another but it would be much easier if one big table.

Thanks for the assitance.
 
P

Paul Overway

In all likelihood, the problem isn't the limit on the number of fields
(which hasn't changed), but the design of your table. Is the table
normalized? I've never seen a normalized table with more than 50
fields...let alone 255.
 
J

John Vinson

I know in the past it has been 256 fields but if it has been increased then
that would solve a problem I am working on now. I have one table linked to
another but it would be much easier if one big table.

Thanks for the assitance.
Click to expand...

Still 255... and as Joseph and Paul say, that's PLENTY.

You almost certainly have one or more one-to-many relationships
embedded in each of these wide-flat records. Could you describe the
content of the table? Dollars to donuts someone can suggest a proper
relational structure rather than your current spreadsheet!

John W. Vinson[MVP]
 
B

Burks

You are correct it is not normalized but there is no repeating data either. I
have since got the problem solved when I was able to fix the relationship
between the two tables.

Thank you for your assistance!
 
Top