Mailmerge data source in an Access database will not open

[Colin C]

I am creating directory in Word 2003 by mailmerge using as the data source a
query in an Access database (prepared in Access 2003 but in 2000 format) .
When I attempt to browse to the data source I find that every table and query
is listed except the one I want.

Approaching the problem via Tools > Office Links etc in Access, the required
query is listed but draws the response " Can not open data source".

The only exceptional feature of the query i can see is that it contains a
number of calculated fields.

 

[Doug Robbins - Word MVP]

From the Tools menu in Word, select Options and then on the General tab,
check the box against the "Confirm conversions at open" item and then when
you attempt to attach the data source, you will be given a number of
different connection methods that you can try. One of them will probably
overcome your problem.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Colin C]

Only a tiny step forward unfortunately. Your recommendation does at least
result in the data source being listed. The option"MS Access databases via
DDE" attempts to open the file but never completes the operation. Other
options get responses "Word can not open file" etc

Thanks for trying.

I would still like to know the answer but I have devised a slightly tedious
workaround by exporting the data from the query to a Word Merge file.

Colin C

 

[Colin C]

Thanks that seems to be the access to the solution.

Colin C