Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"There isn't enough memory to perform this operation..." error after upgrading from Access

Status
Not open for further replies.

TheresAlwaysAWay

Programmer
Mar 15, 2016
135
US
I have a database that has been fully operational for over a decade. It ran without issue in 2007 but after changing to 2019 I'm getting a "There isn't enough memory to perform this operation..." error message.

I'm a heavy macro user and there were two errors in syntax in the old version. When changing to later version those syntax errors stop me from closing, so I correct them and I get the error message when trying to save.

I have decompiled/recompiled the database, and also have changed the MaxLocksPerFile in the registry to 100k. So far nothing works. Do you have any suggestions?

As always, all help is greatly appreciated.
 
BTW, sorry I posted this in the Forms section. I was tired when I did it and I misread it. I thought it said Microsoft Access Forum!
 
If it is a specific form that is causing the error, you can try to export it to text and re-import it:

application.saveastext acForm, "frmFormname", "C:\Temp\frmFormname.txt"

then

application.loadfromtext acForm, "frmFormname", "C:\Temp\frmFormname.txt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top