access-word merge - tables and queries disappear

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

uc user - 21 Apr 2005 23:03 GMT

i have a database in access 2002 with 10 tables and 7 queries. when i try to
mail merge it with word, only 5 tables and 4 queries are visible. the rest
of them just aren't there. i have no idea what to do...any tips or
suggestions would be greatly appreciated, thanks!

Reply to this Message

Peter Jamieson - 22 Apr 2005 11:06 GMT

In Word, check Tools|Options|General|Confirm conversion at open, reconnect
to your Access database, and select the DDE option when offered. This will
only work if you have Access on your machine.

As background, Word can use several different methods to connect to Access
(Jet) data: DDE, ODBC, and in Word 2002 and later, OLEDB. ODBC and OLEDB
cannot work with certain types of query - for example, parameter queries -
in that case Word does not provide the parameter information and neither
OLEDB nor ODBC will do so.

Peter Jamieson

>i have a database in access 2002 with 10 tables and 7 queries. when i try
>to
> mail merge it with word, only 5 tables and 4 queries are visible. the
> rest
> of them just aren't there. i have no idea what to do...any tips or
> suggestions would be greatly appreciated, thanks!

Reply to this Message

uc user - 22 Apr 2005 13:45 GMT

thanks, i will give that a shot!

Reply to this Message