Remembering associated database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allison - 17 Jul 2006 19:56 GMT

XP Professional SP2, Word 2003 SP2:

I have a mail merge document created in Word 2003 that calls fields from an
Access 2003 database.

Each time the document is opened, I have to reconnect the database to the
document. Nobody else uses either file but me.

Both the database and the merge document are in the same directory/folder.

I get the SQL warning, which is okay (and I saw the KB article on how to
disable that). But, when pressing "Yes" to allow the connection, I'm then
presented with a dialog box where I have to browse to my database each time
to establish a connection.

Could you please point me in the direction of where to find a solution for
permanently connecting the source data to the merge document? Thank you.

Reply to this Message

Doug Robbins - Word MVP - 18 Jul 2006 04:45 GMT

Take the steps to eliminate the SQL warning and then save the mail merge
main document after attaching the data source to it.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> XP Professional SP2, Word 2003 SP2:
>
[quoted text clipped - 15 lines]
> Could you please point me in the direction of where to find a solution for
> permanently connecting the source data to the merge document? Thank you.

Reply to this Message

Allison - 18 Jul 2006 10:41 GMT

I cannot eliminate that warning.

The MS KB article said that by selecting yes it would go to the associated
database.

It does not.

I just need it to do what it's supposed to do, preserving the security
warning.

> Take the steps to eliminate the SQL warning and then save the mail merge
> main document after attaching the data source to it.
[quoted text clipped - 18 lines]
> > Could you please point me in the direction of where to find a solution for
> > permanently connecting the source data to the merge document? Thank you.

Reply to this Message

Doug Robbins - Word MVP - 18 Jul 2006 19:42 GMT

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

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

contains information on the steps that you need to take (modifying the
registry) to prevent the message from appearing.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I cannot eliminate that warning.
>
[quoted text clipped - 35 lines]
>> > permanently connecting the source data to the merge document? Thank
>> > you.

Reply to this Message

Allison - 18 Jul 2006 23:55 GMT

Thanks, but I don't want to prevent it from appearing.

I want it to remember the database.

They are not mutually exclusive.

Thanks anyway.

> The article "Opening This Will Run the Following SQL Command" Message When
> You Open a Word Document - 825765 at:
[quoted text clipped - 43 lines]
> >> > permanently connecting the source data to the merge document? Thank
> >> > you.

Reply to this Message

Doug Robbins - Word MVP - 19 Jul 2006 04:48 GMT

If you make the change to the registry as detailed in that article, the
datasource should be remembered.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thanks, but I don't want to prevent it from appearing.
>
[quoted text clipped - 59 lines]
>> >> > permanently connecting the source data to the merge document? Thank
>> >> > you.

Reply to this Message

Rate this thread: