Access chokes on too many Word docs

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

I have an Access program which sequentially opens 300 Word documents. Each
Word document contains about 50 tick box controls.
all the program does is read the ticks and writes them to a table.

About half way through the program stops, Access throws up what looks like a
more or less random error message, and Word complains that it can't leave
design view and create one of the tick boxes.

If I change the order in which the docs are read then the document that it
failed on is happily read without error.

If I close Word and re-open Word every 50 docs then it is better and I can
read maybe 75% of the docs at one go.

I have been careful to close and set to nothing all objects that I create in
the process, this opening of many docs is something I do lot of without
problem. This problem seems to be related to the tick box controls in Word.

I am at a loss, any suggestions welcome.


many thanks

Rod
 
Try running your code with the Task Manager showing and watch the process
count and memory usage. Neither Word nor Access is particularly good at this
sort of thing; Access in particular is a seriously lousy piece of coding
(just look at the literally hundreds of KB articles with work-arounds for
its various problems).

You could try doing *all* the work at the Word end: there's no problem
opening a database (using DAO or ADO) from Word VBA and writing to a
table -- at least that way you'll have only one Office app running, instead
of two.
 
Do you correctly close each word doc after?

I would try putting a doEvents in the loop, and see if that helps.

You don't mention what version, but also make sure all updates are
installed, as those updates often fix things like memory leaks etc.
 
Albert D. Kallal said:
Do you correctly close each word doc after?
Click to expand...

I only do it after every 25 docs, I could try it after every one. but yes I
close it and set to nothing.

I would try putting a doEvents in the loop, and see if that helps.
Click to expand...


You will have to flesh this out a bit for me, I don't follow.

You don't mention what version, but also make sure all updates are
installed, as those updates often fix things like memory leaks etc.
Click to expand...

XP, and recently updated
many thanks
 
Back
Top