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

[Guest]

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.

 

[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.

 

[Joseph Meehan]

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.

One might think that it would be easier with one big table, but that is
not the way databases work. They are designed to work "normalized."

Normalizing takes as little more thought and work on your part, but the
results are there.

 

[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.

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]

 

[Guest]

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!