Word Merge fails as of Office XP SP3

R

Rob_RSD

I have an Access application that launches existing Word documents with mail merge links to the application's back-end (data) database. It is developed in Access/Word 2000 and run from 2000 and 2002. When my clients upgraded Office XP to Service Pack 3, the Word document lost its linkage to the MDB file. It is there, but the merge toolbar is grayed out. You have to reestablish the linkage from scratch. Prior to SP3, I could "resave" the document to retain the linkage, now I cannot

Is this a design feature? Is it a library reference incompatibility? Has anyone else had this problem

TIA

Rob from RSD
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?Um9iX1JTRA==?=,
I have an Access application that launches existing Word documents with mail merge links to
the application's back-end (data) database. It is developed in Access/Word 2000 and run from
2000 and 2002. When my clients upgraded Office XP to Service Pack 3, the Word document lost
its linkage to the MDB file. It is there, but the merge toolbar is grayed out. You have to
reestablish the linkage from scratch. Prior to SP3, I could "resave" the document to retain
the linkage, now I cannot.What your're seeing is the inclusion of a security feature that was first introduced into
Word 2003. If you were to work in the UI you'd get a message warning about SQL execution.
There's a KB article about this

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765
http://support.microsoft.com?kbid=825765

Take careful note of the proposed Registry entries and make sure you create one for the
version of Office you actually have (10 for XP; 11 for 2003).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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 :)
 
R

Rob_RSD

Cindy

Thanks for the reply. I spent a tech support incident on this. The MS tech is working on it now. He seemed to think the problem was more related to the Access MDB being open than that security patch. I can open the document via the UI and click "yes" past that message. If that turns out to be it, I have a problem in that my client will frown on and evenutally prevent me from changing the registry on their workstations. I am learning and will post again when I have a solution


----- Cindy M -WordMVP- wrote: ----

Hi =?Utf-8?B?Um9iX1JTRA==?=,
I have an Access application that launches existing Word documents with mail merge links to
the application's back-end (data) database. It is developed in Access/Word 2000 and run from
2000 and 2002. When my clients upgraded Office XP to Service Pack 3, the Word document lost
its linkage to the MDB file. It is there, but the merge toolbar is grayed out. You have to
reestablish the linkage from scratch. Prior to SP3, I could "resave" the document to retain
the linkage, now I cannot

What your're seeing is the inclusion of a security feature that was first introduced into
Word 2003. If you were to work in the UI you'd get a message warning about SQL execution.
There's a KB article about thi

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765
http://support.microsoft.com?kbid=82576

Take careful note of the proposed Registry entries and make sure you create one for the
version of Office you actually have (10 for XP; 11 for 2003)

Cindy Meiste
INTER-Solutions, Switzerlan
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003
http://www.word.mvps.or

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail :-
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?Um9iX1JTRA==?=,
The MS tech is working on it now. He seemed to think the problem was more related to the
Access MDB being open than that security patch. I can open the document via the UI and
click "yes" past that message. If that turns out to be it, I have a problem in that my
client will frown on and evenutally prevent me from changing the registry on their
workstations.
Mmmm. Maybe I misunderstood your original problem. When you click "Yes" past the message,
the mail merge still doesn't work, then?

Do you know which connection method you used to link to the Access data in the mail merge?
DDE, ODBC or OLEDB? And is the database on a server? If OLEDB and you're on a server it may
be a permissions problem. I picked this up a few months ago and, while I've never had
occasion to use it myself since I never really work in a server environment, you might be
able to do something with it

this issue may occur if the following registry entries and their sub-entries
were not set to Every-Full Control permission.
HKEY_CLASSES_ROOT\Access.Application
HKEY_CLASSES_ROOT\Access.Application.10

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top