WD97: ConfirmConversions Doesn't Work with OpenDataSource
Article ID: 186969
Article Last Modified on 1/23/2007
APPLIES TO
- Microsoft Word 97 Standard Edition
This article was previously published under Q186969
SYMPTOMS
When performing a mail merge using the Visual Basic for Applications
MailMerge.OpenDataSource command with the ConfirmConversions argument set
equal to True, the Confirm Data Source dialog box does not appear when you
open a data source saved in a non-Word format.
WORKAROUND
To work around this problem, you can record a macro while confirming the
data source and use the resulting commands in your original macro.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
Although setting the ConfirmConversions argument to True selects the Select
Method check box option in the Open Data Source dialog box, the Confirm
Data Source dialog box is bypassed when you run the macro. You cannot
select a different method for opening the data source other than the
default method of DDE.
REFERENCES
For additional information, please see the following article in the
Microsoft Knowledge Base:
137385 WD97: Error Using Text Data Source with ODBC Driver
Additional query words: access convert dbase foxpro interop paradox sql
Keywords: kbbug kbpending KB186969