Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Open Mail Merge Doc from MS Access
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? |
#2
|
|||
|
|||
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 "Dan" wrote in message ... 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? |
#3
|
|||
|
|||
Hi ?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 :-) |
#4
|
|||
|
|||
Removing the Application Title solved the problem. In Access 2000 this is
found by using the Tools/Startup dialog box. Thanks. :-) Dan "Cindy M -WordMVP-" wrote: Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge - Access 2000 and Word 2000 | Mailmerge | |||
Mail Merge not running properly from Access Function but runs properly when opened manually | Mailmerge | |||
Web-Site-based Word Mail Merge & Access DB | Mailmerge | |||
Mail merge opens 2nd instance of Access | Mailmerge | |||
Word mail merge with Access | Mailmerge |