Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Remembering associated database
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Remembering associated database
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" wrote in message news 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Remembering associated database
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" wrote: 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" wrote in message news 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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Remembering associated database
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" wrote in message ... 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" wrote: 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" wrote in message news 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. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Remembering associated database
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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message news 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. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Remembering associated database
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 "Allison" wrote in message ... 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert database problem | Tables | |||
Insert Field - Database - Wrong Date Format | Mailmerge | |||
merge document database lost | Mailmerge | |||
DATABASE field placeholder text | Mailmerge | |||
SQL command in DATABASE field | Mailmerge |