Forum Discussion

Copper Contributor

Oct 25, 2020

ODBC (Word Merge and Access DB)

1. I have been doing mail merges for decades using MS WOrd and MS Acces. 2. Currently using Office 365 products. 3. Last successful merge was at end of August 2020 4. No attempts to do merges unti...

George_Hepworth

Silver Contributor

Oct 25, 2020

Chuckz1947 The second image, with the connection dialog, appears to indicate that one or more files have been relocated and the existing connection is not pointing to the new location(s).

Chuckz1947
Copper Contributor
Oct 25, 2020
George_Hepworth
Thank you for your reply.
That’s what it would seem to me too, but the connection string as it reads “DSN=MS Access Database;DBQ=D:\DOCUMENTS - COPY\MASTERFRONT\Master_fe.mdb;DefaultDir=D:\DOCUMENTS - COPY\MASTERFRONT;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;”, appears OK to me for the parts that I understand. What I mean is:

I have a split database and the naming and the path is correct (D:\DOCUMENTS - COPY\MASTERFRONT\Master_fe.mdb). This is where all of my queries, forms and reports are located. “Master_fe.mdb” is the name of my front end.
The odc files are at D:/my data sources.

For the initial catalogue to use, the path is correct as I see it (D:\DOCUMENTS - COPY\MASTERFRONT\Master_fe.mdb),

When I use the “test”, I do not understand why it says “data source name not found” and no default driver specified.

I was wondering whether I should incorporate the following somewhere: D:/my data sources, and if so where, but when I get the opportunity from within the Word merge, to “find” the data source, it does in fact point to the subdirectory “my data sources”.

What about installing a fresh ODBC driver?

Resources