Link to home
Start Free TrialLog in
Avatar of Helen Feddema
Helen FeddemaFlag for United States of America

asked on

Hotfix for System Resource Exceeded error in Access 2016

A client is having Error 3035 System Resource Exceeded when running Access 2016 VBA code to update a local table from a large SQL Server table.  I found a KB article on a hotfix for this problem in Access 2013 -- has anyone tried it for Access 2016, or maybe has another solution for this problem?
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Helen Feddema

ASKER

Will try the DAO statement first, and let you know what happens.  I would rather not tinker with the Registry if it can be avoided.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I haven't heard a peep from the client for over a week. so it appears that resetting the locks much higher did the job.