General discussion

Locked

Mailmerge word 2002 - Access 2002

By HBB ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Mailmerge word 2002 - Access 2002

by timfox In reply to Mailmerge word 2002 - Acc ...

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

Collapse -

Mailmerge word 2002 - Access 2002

by HBB In reply to Mailmerge word 2002 - Acc ...

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

Collapse -

Mailmerge word 2002 - Access 2002

by HBB In reply to Mailmerge word 2002 - Acc ...

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.

Collapse -

by HBB In reply to Mailmerge word 2002 - Acc ...

This question was closed by the author

Related Discussions

Related Forums