T
TD
I have developed a database in Access 2000 which has been working fine for
years - now I've moved on to Access 2003 mailmerges have stopped working.
I have read and tried the posts on this board and on the Microsoft Support
web site (and loads of others too) - none of which resolved the problem.
When I try to link a Microsoft Word 2003 document to a Query (or even a
table) in Access 2003 using "MS Access databases via DDE", I get the message:
"Word could not establish a DDE connection to Microsoft Access to complete
the current task" before you get the chance to choose a Table or Query to
link to.
I have to use DDE as many of the queries are parameter queries (so ODBC and
OLE DB won't work for that - I think). The settings in Word are fine for
Confirm Conversions on Open and the database is not open in exclusive mode.
After hours of trying different things, I have found that deleting 70 or so
Queries from my database (of approximately 600 queries) makes everything
works fine. Any 70 or so queries being deleted is fine - it doesn't matter
which ones (so it probably isn't a corruption in a query).
I have over 200 forms - the number of these makes no difference. I have
nearly 100 reports - no difference either.
I have tried separating the front and back end - no difference. I've ported
it from Access 2000 format to Access 2003 format and still no difference.
Compact & Repair or convertion to MDE makes no difference either. I have
created a blank database and imported all the forms and queries in - still no
change.
Has anyone else come across a similar problem in the past for which they
have found a solution? Worst case scenario I'll have to go back to the
comfort of Access 2000 or find 70 queries I don't need any more
Thanks in anticipation of any guidance! I hope I've posted this in the
right place.
years - now I've moved on to Access 2003 mailmerges have stopped working.
I have read and tried the posts on this board and on the Microsoft Support
web site (and loads of others too) - none of which resolved the problem.
When I try to link a Microsoft Word 2003 document to a Query (or even a
table) in Access 2003 using "MS Access databases via DDE", I get the message:
"Word could not establish a DDE connection to Microsoft Access to complete
the current task" before you get the chance to choose a Table or Query to
link to.
I have to use DDE as many of the queries are parameter queries (so ODBC and
OLE DB won't work for that - I think). The settings in Word are fine for
Confirm Conversions on Open and the database is not open in exclusive mode.
After hours of trying different things, I have found that deleting 70 or so
Queries from my database (of approximately 600 queries) makes everything
works fine. Any 70 or so queries being deleted is fine - it doesn't matter
which ones (so it probably isn't a corruption in a query).
I have over 200 forms - the number of these makes no difference. I have
nearly 100 reports - no difference either.
I have tried separating the front and back end - no difference. I've ported
it from Access 2000 format to Access 2003 format and still no difference.
Compact & Repair or convertion to MDE makes no difference either. I have
created a blank database and imported all the forms and queries in - still no
change.
Has anyone else come across a similar problem in the past for which they
have found a solution? Worst case scenario I'll have to go back to the
comfort of Access 2000 or find 70 queries I don't need any more
Thanks in anticipation of any guidance! I hope I've posted this in the
right place.