[AccessD] Automating word

Jim Lawrence accessd at shaw.ca
Mon May 13 18:56:34 CDT 2013


Hi John:

As if you have not heard this before to, ad nauseum... PTQs are bad, ADO is
good and that was right in 1997 and it is right in 2013. :-) You can switch
back and forth with ease from MDB to a real SQL without shifting gears.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Monday, May 13, 2013 12:33 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Automating word

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list