WD2000: Cannot Connect to a Data Source While Performing a Mail Merge Operation (315932)
The information in this article applies to:
- Microsoft Word 2000
- 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 file
name. - 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.
| Modification Type: | Minor | Last Reviewed: | 1/6/2006 |
|---|
| Keywords: | kbBug kbnofix KB315932 |
|---|
|