Hello,

I have a large number of word documents that I mail merge
with an access database. Every time I open my word
documents it opens 3 copies of Access. I know that 1 is
from me setting it as the data source, 1 from choosing the
table for that data source and 1 from when I limit the
records it returns.

It seems the only clean way to stop this is to open the
database via ODBC - which I would be happy to do.

Unfortunately when I try that - at the stage of selecting
the data source it finds the DB and shows my tables and
queries etc., but no fields? This seems to be the same
with using MSQUERY also. I have tried all sorts of things
to make this work, but can't.

Is there any other way to stop multiple copies of access
opening (I have checked that I haven't modded the
caption),or can anyone tell me how to make the ODBC
connection work?

I am using Office Professional 2000.

Any help would be much appreciated.
Regards
Mark