Discussion Locked

Mailmerge word 2002 - Access 2002

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

OS = Windows XP Pro
Office = XP Pro
word hangs during a mail merge creation when trying to access the 2002 database.
Other backdoor attempts have given the error "Word was unable to open the data source"
Database is stored on a network server.
any help to solve this problem would be appreciated.

4 replies

by timfox

May be related to a number of problems, as follows:
- Check for any restrictions to the recordset, when using a general user's connection (no login required).
- Check that the query (if used) is not a parameter query that is waiting for input.
- Check that the recordset will open and does not have any data columns that cannot be evaluated etc.
- Check for timeouts that may prevent proper database connection.
- Check that your connection from Word does not apply incorrect filters etc.

Hope this helps
TimFox

by hbb

these things helped to troubleshoot but not resolve the issue. I have added additional info as a comment elsewhere

by hbb

Info just to hand
This problem has been duplicated in another environment indicating that this Database/network may not be the problem.
A work around has been achieved by exporting to another file and then using that file as the source for the mail merge. Another organisation is currently working to reolve this as well.

This discussion is closed to new replies.