[AccessD] Automating word

John W Colby jwcolby at gmail.com
Mon May 13 14:32:37 CDT 2013


Pretty much sucks.

Sigh.

I have code that works now... if the query is a stored procedure pass through to SQL
Server.  If it is just a local query to a linked table in Access it fails with the very helpful 
error 5922 "Word was unable to open the data source".

Does anyone know the magic for switching between ODBC pass through queries and local queries?  It 
seems to have to do with the MailMerge.OpenDataSource parameters but I have spent hours futzing with 
this and I do have it working ... for pass through queries.

-- 
John W. Colby

Reality is what refuses to go away
when you do not believe in it



More information about the AccessD mailing list