Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Mailmerge data source in an Access database will not open
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. |
#2
|
|||
|
|||
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" Colin wrote in message ... 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. |
#3
|
|||
|
|||
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 "Doug Robbins - Word MVP" wrote: 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" Colin wrote in message ... 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. |
#4
|
|||
|
|||
Thanks that seems to be the access to the solution.
Colin C "Doug Robbins - Word MVP" wrote: 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" Colin wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Find Its Data Source | Mailmerge | |||
Using as secured Access database as the data source for a mail mer | Mailmerge | |||
Open Data Source Dialog Box | Mailmerge | |||
Mailmerge wont see Added Excel Data source Columns | Mailmerge | |||
Merge Data Source path | Mailmerge |