Remembering associated database

[Allison]

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.

 

[Doug Robbins - Word MVP]

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

--
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

 

[Allison]

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.

 

[Doug Robbins - Word MVP]

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.

--
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

 

[Allison]

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.

 

[Doug Robbins - Word MVP]

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

--
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