Re: How to Bypass "not enough memory to undo" nmessages
- From: "david epsom dot com dot au" <david@epsomdotcomdotau>
- Date: Tue, 11 Apr 2006 15:05:47 +1000
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)
"Phil" <phil_at_nhs@xxxxxxxxxxx> wrote in message
news:O4zj$wOXGHA.1348@xxxxxxxxxxxxxxxxxxxxxxx
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?
.
- References:
- Prev by Date: Re: Remove time stamp
- Next by Date: Re: Thermodata query problem
- Previous by thread: How to Bypass "not enough memory to undo" nmessages
- Next by thread: Re: how do you find and use the integer function in Access?
- Index(es):
Relevant Pages
|
