Microsoft Access: System Resource Exceeded

%3CLINGO-SUB%20id%3D%22lingo-sub-1589265%22%20slang%3D%22en-US%22%3EMicrosoft%20Access%3A%20System%20Resource%20Exceeded%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589265%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Microsoft%20Access%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaving%20problems%20with%20just%20one%20table%20and%20only%20one%20table%20in%20an%20Access.%3C%2FP%3E%3CP%3EWhen%20I%20open%20up%20the%20table%2C%20I%20get%20%22System%20Resource%20Exceeded%22%3C%2FP%3E%3CP%3ESo%20have%20done%20the%20following%3C%2FP%3E%3CP%3E1.)%20Compact%20and%20Repair.%20That%20did%20not%20work.%3C%2FP%3E%3CP%3E2.)%20I%20copied%20the%20table%20to%20another%20clean%20database.%20Deleted%20the%20original%20table.%20Copied%20the%20table%20back.%20Compact%20and%20repaired.%20That%20did%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20only%20happens%20when%20I%20open%20that%20one%20table.%20No%20other%20table%20has%20this%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am using Microsoft Access 2016.

 

Having problems with just one table and only one table in an Access.

When I open up the table, I get "System Resource Exceeded"

So have done the following

1.) Compact and Repair. That did not work.

2.) I copied the table to another clean database. Deleted the original table. Copied the table back. Compact and repaired. That did not work.

 

The problem only happens when I open that one table. No other table has this problem.

0 Replies