Suppressing error messages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Orban - 18 Feb 2004 16:31 GMT

I have an access database tied to a word document. Upon opening the Word
document (with an Access macro) a message pops up warning the user that a
SQL query is about to extract data from the database and asking for
permission to proceed.

Is there any way to suppress this message? I have turned Macro security to
low in Word and that doesn't seem to have anything to do with it.
Suppressing Warnings in the Macro editor in Access doesn't help.

Also, I don't understand why, when you save the document with the data
source identified that Word still asks the user where the data source is
located.

Any help would be appreciated.

John Orban
The Country School
Easton, MD.

Reply to this Message

Peter Jamieson - 19 Feb 2004 07:29 GMT

This is probably a consequence of a new security check in Word 2003. - see
the following KnowledgeBase article

"Opening This Will Run the Following SQL Command" Message
When You Open a Word Document - 825765

http://support.microsoft.com?kbid=825765

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I have an access database tied to a word document. Upon opening the Word
> document (with an Access macro) a message pops up warning the user that a
[quoted text clipped - 14 lines]
> The Country School
> Easton, MD.

Reply to this Message

John Orban - 19 Feb 2004 13:05 GMT

YOU DA MAN!

Thank you!!!!!

John

> This is probably a consequence of a new security check in Word 2003. - see
> the following KnowledgeBase article
[quoted text clipped - 26 lines]
> > The Country School
> > Easton, MD.

Reply to this Message