General discussion

Locked

Problem automating mail merge error 2754

By munrrob ·
Hi,

We are having problems with a client who is running an old version of our
software on Access version 2. The platform he is running on is Windows 98
SE.

There is a facility in our package to use mail merge to Word. The Word
version he isusing is 97. The problem he is getting is that the merge fails
with the error no 2754 - Unable to open DataSource during mail merge. If he
does the mail merge manually the merge works, it only fails if automated
using OLE.

We have checked thatthere are no text drivers in the ODBC connections as we
have experienced these causing problems in the past.

I thank you in advance for your assistance.

Regards

Bob Munro

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Problem automating mail merge error 2754

by C1980 In reply to Problem automating mail m ...

I may be a compatability issue, in which case you would need to update software.

But it could also be an inteference with an antivirus program like NAV. NAV causes problems with OLE objects. Try de-installing, (not just deactivating), if you havean anvi-virus prg. and see if it still happens. I did this and my problems went away immediately, and this problem, (OLE), is listed as a bug with NAV. I believe NAV 2002 is ok.

If that doesn't work, then check if you have the latest service packs of Word 97, Access and the OS.

Last, import the tables to Access 97, if available, and see what happens. If the problem goes away, then it is a bug or a compatability problem.

Collapse -

Problem automating mail merge error 2754

by Shanghai Sam In reply to Problem automating mail m ...

Problem was due to NAV. Thanks for your help.

Bob

Collapse -

Problem automating mail merge error 2754

by munrrob In reply to Problem automating mail m ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums