Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2005

Tip: Looking for answers? Try searching our database.

Open Mail Merge Doc from MS Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dan - 22 Jun 2005 03:07 GMT
When I open a Word mail merge doc using code in an Access db a second
instance of the Access database is opened. Is there any way to prevent this
from happening?
Peter Jamieson - 23 Jun 2005 10:55 GMT
First, if you are changing the text in the Windows title bar in your Access
application, if possible, change your Access datbase properties or whatever
so that it uses the default title and see if that helps.

Otherwise, it depends. For one thing, Word can use different connection
methods to get its data from Access:
a. DDE - in all versions of (Windows) Word from 97 to 2003. The default in
97 & 2000
b. ODBC  - in all versions of (Windows) Word from 97 to 2003
c. OLEDB - only Word 2002 and 2003

DDE is the only one that opens a copy of Access. The others use the
underlying Jet database engine to get the data. In some cases you /have/ to
use DDE because the relevant features are only available when Word is using
Access (rather than Jet) to get its data. In other cases, Word can get its
data via Jet, as long as there are no sharing problems. For example, you
have to use DDE if your data source is a parameter query or uses
user-defined functions written in Access VBA, and in some other cases.

So it may be worth trying to get your Word merge document to open its data
source using ODBC (or OLEDB if available). From your description it sounds
as if you are probably using Word 97 or 2000, in which case, when you
connect to the Access data source in the Open Data Source dialog box, you
should check the "Select Method" box. You will then see an extra dialog box
which lets you choose DDE or ODBC, as long as ODBC is installed on your
system.

Peter Jamieson

> When I open a Word mail merge doc using code in an Access db a second
> instance of the Access database is opened. Is there any way to prevent
> this
> from happening?
Cindy M  -WordMVP- - 23 Jun 2005 11:37 GMT
Hi =?Utf-8?B?RGFu?=,

> When I open a Word mail merge doc using code in an Access db a second
> instance of the Access database is opened. Is there any way to prevent this
> from happening?

Using a DDE connection, I presume? Sometimes, you can make this stop by
removing any customized title bar you've assigned to the Access database
(Tools/Options dialog box).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Dan - 23 Jun 2005 15:16 GMT
Removing the Application Title solved the problem. In Access 2000 this is
found by using the Tools/Startup dialog box. Thanks. :-)

Dan

> Hi =?Utf-8?B?RGFu?=,
>
[quoted text clipped - 13 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.