I have an Access 2007 file with 236 columns.  When I try opening it or importing it into Access 2013 all of my columns are there, but it will not let me add more columns in either mode (too many fields).  If I open a new table I can make it have 255 columns.  Any idea on how to fix this?  I have only one key column.

• Moved by Lanlan HuangMicrosoft contingent staff Friday, April 10, 2015 5:31 AM

I am in Access 2007 ACCDB.  I want to add columns into the Table.  I have unhidden all of the columns and also counted in the Design view and only have 236 columns.  Any other thoughts?  THANKS!!

Hi,

Do you mind sharing us a sample file here via OneDrive? Or send to us via email (ibsofc@microsoft.com).

Please note: Add the thread url or title in the email.

Regards,

George Zhao
TechNet Community Support