Avatar of mlcktmguy
Flag for United States of America

asked on 

TransferSpreadsheet generates 3035, System Resources Exceed

I have an Access 2003 app that has been running in production for a couple years.  In that period, the statement I am getting this error on has run many, many times.  However, the last couple of months the users are getting the 3035 error.

There have been no application changes but the data size has grown over the last couple of years.

The statement that is throwing the error is:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "qryRpt_InstallPlan_Letters_Export_2", wkExportNameAndLoc, True

Open in new window

There are a couple process that run prior to this statement pulling together the data that is needed on the export but they always run successfully.

Any ideas what can be done to eliminate this issue?
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon