system resources exceeded error

George_Hepworth 

Thanks.

First, in your first reply, you said version 2010. Do you mean I should install Access 2010? I am using Access 2016.

Second reply, in Run command, I entered

Start.exe /affinity 1 C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE d:\Documents\Racing

Is says Cannot find Start.exe

(I am not a programmer. )

The more I try work arounds in my DB, the worse it appears to be.

The table where the system resources exceeded error appeared had 400,000 records.

I managed to move out 300,000 of these records into another archive file.

Yesterday, my DB was mostly working with the cut down 100,000 record size table. Occasionally, system resources when using it in form queries, but I closed that form and didn't bother proceeding with that one.

TodayI am trying to devise other work arounds that will allow me to continue to add more records to this table, by Copying the 100,000 file to a temp file, clean out original, do my updating to original which has 0 records, then return the temp records. 

But now, Access won't even let me do the Copy of the original table, reporting system resources exceeded.

This issue only arose after a W10 update, and then MS updated my Office programs on Thursday.

The MS help people are no use, claiming no knowledge.

Thank you so much for your assistance.

Neville Aganoff