How to Bypass "not enough memory to undo" nmessages

[Phil]

I hae a series of quieries rolled into a macro. Large amount of data
and many transitional steps results in an hour or more runtime, and of
course, lots of messages saying there is inusfficient memory to undo...

Now, I have seen the Reg fix where you increase the the number of locks.
Does not seem to help with 3 million or so records in each update.

Sendkey seems to be useless.

Any ideas?

 

[david epsom dot com dot au]

1) use code instead of macro's

and

2) code like this
Dim qdf As DAO.QueryDef
Dim db As DAO.Database
Dim prm As DAO.Parameter


set db = currentdb

db.execute "name of my query 1"
db.execute "name of my query 2"
db.execute "name of my query 3"

This will run much faster, and will have no messages at all.
If you have in your queries references to forms, you will
have to resolve them before running the query, like this:

set qdf = db.querydefs("name of my query")
for each prm in qdf.parameters
prm = eval(prm.name)
next prm
qdf.execute

(david)

 

[Guest]

At the beginning of the macro Set Warnings Off and, this is very important,
at the end of the macro Set Warnings back On.

Also with 3 million records and an hour of processing time, you might want
to consider another database such as Oracle or SQL Server plus a good server
to do the work.

Also you may have some inefficiencies in how you are doing the work. It's
possible that some coding and design changes could speed things up.