The mail merge is being called from the Access database via a Visual Basic
function. The message that comes up is:
Data Link Properties
Connection
Specify the following to connect to Access Data
1. Select or enter a database name
(default to open db)
2. Enter information to log onto the database
User Name: Admin

When Cancel is selected a second page pops up called
Login
Data Source MS Access Database

When Cancel is selected the mail merge proceeds using DDE.

Any ideas?


"Peter Jamieson" wrote:

What does the pop-up say?

Peter Jamieson
"mvb" wrote in message
...
No luck with a. I'm afraid. The merge does work when the pop-up asking
for
data source location is cancelled. The link is in DDE and it goes ahead
ok -
it's just a nuisance having to cancel the pop-up each time the merge is
run.
What does method b. involve?

Mvb

"Peter Jamieson" wrote:

If nothing else works, you can try:
a. changing the method Word uses to connect to Access (check Word
Tools|Options|General|Confirm conversions at open, and go through the
connection process again). In Word 2003, the default method is OLEDB, but
you should be able to choose DDE (the old method) or ODBC.
b. setting up an appropriate .odc or .udl file and opening that
instead -
you may need that if your database is secured via workgroup security. If
(a)
doesn't work and you need to use (b), I'll try to explain more.

Peter Jamieson
"mvb" wrote in message
...
When starting a mail merge from access to word 2003, word prompts for
location of the data source every time even though the merge has been
saved.
This behaviour is new with word 2003 and did not occur with word 2000.
Microsoft acknowledged the problem and provided an update (885832 &
887979)
but this didn't have any effect. Any suggestions???
Thanks.