using ODC with multiple versions of Word

[JP]

I created an ODC for a mail merge that works fine in
2000,XP, and 2003. However, if that data changes (though
a seperate application), If you are running Word 2000 or
XP, when you re-open the word document, the data is not
updated, but if your running 2003, it warns you the it
needs to run a SQL view and the data gets updated in the
view.

I tried placing both the ODC file and Word file on a web
server thinking it was b/c the ODC file only updated the
data b/c the file was on the same PC as the ODC. That
does not update the data either. So that tells me its the
ODC file itself that does not refresh each time the user
load the document from the web. Is there a way to refresh
the document (or ODC file) each time the doc is loaded.
Keep in mind the document loads in the ActiveX control
for Word though the web browser.

 

[Peter Jamieson]

I'm not sure what you are actually doing here because as far as I know
a. .odc files can't be used to specify a data source in Word 2000, only XP
and 2003
b. I do not think Word would be able to use a .odc file located at a URL,
only on a local drive or at a UNC name (i.e. openable via Microsoft
networking rather than Internet protocls)

Which leads me to suspect that Word may not be doing quite what you think it
is doing. However
c. I may well be wrong
d. it would help to know what the data source is.

 

[Cindy M -WordMVP-]

Hi Jp,

I created an ODC for a mail merge that works fine in
2000,XP, and 2003.

OK, now I'm really confused. Word 2000 simply does not
support OLE DB connections, which is when *.odc files are
required. As far as I know, these things were new in Office
XP.

What kind of data source is this for?

Keep in mind the document loads in the ActiveX control
for Word though the web browser.

??? Using some kind of automation, then? And what happens
if the document is opened in the normal Word interface?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Guest]

Its cacheing the ODC on the local machine. The ODC file
contains all the records from when the file was created
initially. I need the file to run the SQL view each time
the Word file is open to ensure the data is the most
current