Max. number of columns in Access 2003

[milos111]

I am trying to find the way to extend the maximal number of columns in acces tables. As far as I know the maximum is 250 or so. I need to have about 300 fields on the same form. If I put a subform, then I can not easily navigate through records - I can not navigate through records on a subform during navigation on a main form at the same time . So, either I have to extend the number of columns on main form, or make subform somehow navigate together with the records on a main form. I am not shure whether I can do that, so maybe someone could help me on this one.
Thanks

 

[Rich]

Why the need for so many fields, is your structure normalised?

 

[ColinEssex]

If your database is correctly constructed, there is very seldom any need for a max of even 20 fields.

As Rich says, check out normalisation and relationships.

Col

 

[tikkat3]

The datasheet for Access 2007 states the maximum no of fields is 255. 2003 will certainly not have any more than this.

 

[boblarson]

If your database is correctly constructed, there is very seldom any need for a max of even 20 fields.

As Rich says, check out normalisation and relationships.

Col

I second this...what it sounds like is that you're trying to use Access like a spreadsheet instead of as a relational database system.

 

[Dennisk]

if you do have a large dataset split it up into one or more tables and link on one to one.

I work in the Health service and sometimes we need to record up to 200 items of information for one Patient Referral so it does happen. And one database I developed used by our Information dept does have in excess of 255 columns (split into two tables).

 

[Ron_dK]

....And one database I developed used by our Information dept does have in excess of 255 columns (split into two tables).

I guess that's the answer to the posters question.
If you need more , add another table with new fields. Make a query which gets the data from the various fields in various tables, and bound the form to the query.

Hth