Caroline,
I am still having problems.
Your OpenDataSource seems much simpler than mine, which I LIKE SIMPLE.
In trying to compare the difference to see WHY I still cannot attach the data source the only thing that might be different is my value for the DSN.
What are you setting this value to?
I am not opposed to change, just so long as I get this _____ thing working.
Thanks for your help.
Lee Raulerson
Lee,
I just recently had the exact same problem and all I did was to keep the code exactly the same as it had previously been to run with other versions of Word, I just make the change below to tell word to use the Word2000 ODBC DataSource if it was the XP version.
The code I use is as follows:
lcDSN = "DSN="+lcDSN+";SourceDB="+FullPath(lcDBC)+";SourceType=DBC;"
lcSQLStatement = [SELECT * FROM ]+lcTable
If This.WordVersion = 10
.OpenDataSource(,,,.T.,,,,,,,,lcDSN,lcSQLStatement,,,wdMergeSubTypeWord2000)
Else
.OpenDataSource(,,,.T.,,,,,,,,lcDSN,lcSQLStatement)
EndIf
HTH
Caroline