headers number reach 255 into a table

[Alt]

I have a friend which have reach the access headers limits into a table. What's the best solution (ex. split content into another one)?

Regards!

 

[plog]

Your "friend" should read up on normalization:

Database normalization - Wikipedia

en.m.wikipedia.org

That's the process of properly setting up your tables. Give it a read, work thru some tutorials and then apply what you learn to your data. Sorry, your friends data. You could also post a screenshot of the table so we can see all it's fields and we can give you/your friend specific advice

 

[Alt]

After looking carefully into his works, I found out than he put headers for 4 different reports. I think the best will be to split those fields into 3 new different tables and used specific keys on each new tables.

reports:
1- instruments list (only one document, weekly issued)
2- instruments datasheets (each datasheet will be generated in excel and will have a specific DocNo)
3- process conditions (linked to the instruments datasheets, only tracking import date from cells)
4- documents tracker (to track 1 to 3 above)

 

[GPGeorge]

After looking carefully into his works, I found out than he put headers for 4 different reports. I think the best will be to split those fields into 3 new different tables and used specific keys on each new tables.

reports:
1- instruments list (only one document, weekly issued)
2- instruments datasheets (each datasheet will be generated in excel and will have a specific DocNo)
3- process conditions (linked to the instruments datasheets, only tracking import date from cells)
4- documents tracker (to track 1 to 3 above)

Here's an excellent series of articles that describe the problem of spreadsheet style tables, and more importantly, how to fix them (and no, it's not just randomly splitting fields off into new tables). Roger applies the rules of normalization to the problem. You should help your friend do the same.