Hi Graham,
Is there any way to embed the SQL Server connection information right
into a Word document? I'd like to be able to e-mail the document to
others within the organization without having to navigate them through
the process of creating a data source. (They all have access to the SQL
server, of course.)
Which version of Word are we discussing? And do your systems have an ODBC
driver for SQL Server installed?
I think it can't be done for OLE DB, as this also requires an external
*.odc file. ODBC can probably do it. And a macro that links the data
source when the file opens could probably work.
Another possibility (and it's what MSFT had in mind when they designed
the interface) would be to distribute the *.odc file for the connection
to everyone's "My Data Source" folder.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)