system resource exceeded error

[mopey12345]

Hi,
Started to get this error "system resource exceeded error" on a PC running Access 2010. Other PCs on the latest version 365 don't. Did anyone find a fix or is upgrade the only solution. Thanks Phil

 

[mopey12345]

Hi,
Started to get this error "system resource exceeded error" on a PC running Access 2010. Other PCs on the latest version 365 don't. Did anyone find a fix or is upgrade the only solution. Thanks Phil

Here's the solution; affinities have to be set so that it runs on just one processor. This needs to be added to the command line when you boot access.

C:\Windows\System32\cmd.exe /c start "Microsoft Access" /Affinity 1 "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE"