Harold
Mon Oct 13 18:42:46 CDT 2003
Hi Chris,
You might want to try using the Subtype property in the Connection string.
SubType:=8 'wdMergeSubTypeWord2000
If you're using the code for both Word 2000 and 2002, you will need to test
the version and not use Subtype if the Word version is not Word 2002.
This article discusses subtype
324378 WD2002: Undocumented OpenDataSource Method Expression [SubType]
http://support.microsoft.com/?id=324378
--
Harold Kless, MCSD
Support Professional
Microsoft Technical Support for Business Applications
haroldk@microsoft.com
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.
"Chris Kennedy" <chrisk@cybase.co.uk> wrote in message
news:239eb2fd.0310110254.10a66fe0@posting.google.com...
> I have a VBA procedure in Access which opens up Word and creates a
> mail merge based on a dynamicly created SQL statement. It works in
> Word 2000 but not in XP. In XP I get a 'data source could not be
> opened' error. It connects via OLEDB. I am also sure it is not a
> network security issue as the two machines access the same network
> share but using XP and 2000 respectively. Unfortunately I don't have
> the code at hand. I was just wondering if there was something obvious.