Microsoft KB Archive/315932

= WD2000: Cannot Connect to a Data Source While Performing a Mail Merge Operation =

Article ID: 315932

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Word 2000 Standard Edition
 * Microsoft Visual Basic for Applications 5.0

-



This article was previously published under Q315932



SYMPTOMS
When you try to perform a mail merge and connect to a data source, one of the following problems may occur:  If you use the Mail Merge Wizard, nothing may occur after you select your data source file in Step 2, or you may receive the following error message:

Word was unable to open the datasource.

 If you use Microsoft Query, you may receive the following error message:

ODBC Microsoft Access Driver Login Failed

Could not find file.

 If you use Visual Basic for Applications (VBA) code, you may receive the following error message:

Run-time error '9105'

String longer than 255 characters

 If you use VBA code, you may get various error messages that are related to information missing from the connection string. If you view the connection string in the Visual Basic Editor Immediate Window, after pausing your code, you may notice that only the first 255 characters are present. The rest of the connection string has been dropped.



CAUSE
This problem occurs because Word cannot create a connection string that is longer than 255 characters.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: kbvba

Keywords: kbbug kbnofix KB315932

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.