slow merge Access query into Word

M

Mad Mo

I use DDE to merge a Query from Access into Word so I can use all queries
from the database. The problem is though that it takes a long time before
Access responds. In word it says that word is busy waiting for MsAccess to
accept DDE.
Does anyone how to speed this up?
 
A

Albert D. Kallal

Gee, allow word to "attach" to ms-access is not the best solution if you can
avoid this. All kinds of issues from security, passwords, and even what
version of ms-access to launch (I currently have 3 versions of ms-access
installed on my pc).

To eliminate all these problems, the best sot is to provide a nice form in
ms-access that launches word. This approach lets you manage how word will
gets its data.

I have a sample word merge example here (including data). Give it a try


Of course, my solution does means that you have to build a prompt form that
allows the user to select the query, but that is so much more user friendly
anyway...

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
[email protected]
http://www.attcanada.net/~kallal.msn
 
Top