Macro Security

[Dan]

I am using VBA in an Access 2003 database to open a Word 2003 mail merge
document that is attached to the database. Even with the Word macro security
settings set to low the mail merge document is not connecting to the data
source. I have looked through various macro security documents to no avail.
Can anyone shed some light on what's happening?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RGFu?=,

I am using VBA in an Access 2003 database to open a Word 2003 mail merge
document that is attached to the database. Even with the Word macro security
settings set to low the mail merge document is not connecting to the data
source.

See this article

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

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]

Yes, I had read this article previously but it is not exactly clear. So, even
though I answer YES to the SQL prompt the merge document will not connect to
its data source? In order to allow the doc to connect I need to edit the
registry as per the article regardless of the macro security level setting?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RGFu?=,

Yes, I had read this article previously but it is not exactly clear. So, even
though I answer YES to the SQL prompt the merge document will not connect to
its data source? In order to allow the doc to connect I need to edit the
registry as per the article regardless of the macro security level setting?

When you use VBA to open a mail merge document, it cuts off the data source
without prompting. You have basically two choices:

1. Use the OpenDataSource method in your VBA code in order to link the data
source in each time

2. Set the Registry key mentioned in the article so that the SQL prompt is
completely disabled on the machine

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]

The IT dept has nixed the registry edit mechanism, so, I'll have to use the
OpenDataSource Method. Can I run this method using MS Access VBA or will I
still run into the same problem? I have made a couple initial attempts with
no success. My initial code is as follows:

Set oDoc = GetObject(Forms![frmDocsMain]![Sub]![FilePath], "Word.Document")
oDoc.Application.Visible = True
oDoc.Application.WindowState = wdWindowStateMaximize

If its possible, from here I'm not exactly sure how to proceed with the
OpenDataSource code.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RGFu?=,

Can I run this method using MS Access VBA or will I
still run into the same problem? I have made a couple initial attempts with
no success. My initial code is as follows:

Set oDoc = GetObject(Forms![frmDocsMain]![Sub]![FilePath], "Word.Document")
oDoc.Application.Visible = True
oDoc.Application.WindowState = wdWindowStateMaximize

If its possible, from here I'm not exactly sure how to proceed with the
OpenDataSource code.

Best is to record linking to the data source in a Word macro, then copy the
result into your automation code and make any necessary adjustments (such as
replacing the hard-coded file path with a variable).

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