access-word merge - tables and queries disappear

[uc user]

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!

 

[Peter Jamieson]

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

 

[uc user]

thanks, i will give that a shot!