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

[TheresAlwaysAWay]

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.

 

[TheresAlwaysAWay]

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!

 

[Axworthy]

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