Speed up Access

[Chris]

I use Access as the database with my Word mail merge
document. Problem is the slow merge. I use a querry
with a parameter value as the data source. Any way to
speed up the time it takes for the Access Parameter Value
box to appear? Thanks for you time!

 

[davidjpike]

You could try looking at your query to see if it is generating a lot of
unwanted data. Or sometimes instead of running one massive query, try
two or three small stepped ones. The last one having your parameter.
Though there are loads of different ways to do this, thats one i've
sometimes tried.

Dave

 

[John Vinson]

I use Access as the database with my Word mail merge
document. Problem is the slow merge. I use a querry
with a parameter value as the data source. Any way to
speed up the time it takes for the Access Parameter Value
box to appear? Thanks for you time!

In addition to David's suggestions, make sure that there is an Index
on the field that you're searching, and on any field you're using for
sorting. This won't speed the opening of the parameter value box
though: I suspect that delay is due to the fact that Word must
actually open Access, which in turn must open your database. I don't
know that it will help, but try opening your database in the
background before starting the mailmerge (that will at least move the
slow step).

John W. Vinson[MVP]