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 1 hour 57 minutes ago

Hi KrisMarshall7,

Since this forum is discussing about the Access developing, and your issue is more related with the product feature of the Access, I will move this thread to the more related forum.

Reference: http://social.technet.microsoft.com/Forums/en-US/home?forum=officeitpro

Thanks for your understanding.

Best Regards,

Edward