Mail merge in word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

arenac - 27 Nov 2006 22:00 GMT

Its an access 97 database. The mail merge document works fine on all
machines not running office 2003 and a few machines running office
2003. On office 2003 machines when you open the mail merge document,
it asks for the data source. After you point it to the data source, it

looks asking you for the data source again.

Does anyone know what is causing this? I tried comparing the settings
and all on the machines that were working but couldn't find anything
different. The database and mail merge document both sit on a network
drive.

The communication is through DDE

Reply to this Message

Peter Jamieson - 30 Nov 2006 13:44 GMT

The really obvious setting that would affect /any/ DDE connection
(regardless of the Access database version) is Access
Tools|Options|Advanced|"Ignore DDE requests"

However, when Word uses DDE to open a .mdb it has to start Access, then get
Access to open the database, then get the data. So...
a. Do you have any difficulties with DDE connections to Access 2000 (or
later) format .mdbs, on the "problem" machines
b. if you open the Access 97 format database on a "problem" machine and on
a "non-problem" machine, do you see the same dialogs? For example, here I
would typically see
- a message related to the macro security level
- a message related to the fact that Access 97 databases cannot be altered.
If I had workgroup secuirty set up, I might also expect to see a login
dialog.

That's just about all I can think of right now, except...what kind of folder
is being shared? is it a regular Windows file system folder, or something a
bit more esoteric such as a Sharepoint document list?

Peter Jamieson

> Its an access 97 database. The mail merge document works fine on all
> machines not running office 2003 and a few machines running office
[quoted text clipped - 9 lines]
>
> The communication is through DDE

Reply to this Message

Rate this thread: