Can't Insert Access 7 Database if Path Contains Apostrophe
Article ID: 148121
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Word 95 Standard Edition
- Microsoft Word 95a
This article was previously published under Q148121
SYMPTOMS
When you insert a Microsoft Access 7.0 database into a Word document via
ODBC, or when you attach a Microsoft Access 7.0 data source to a mail
merge main document via ODBC, you get one of the following error messages:
Windows 95
----------
Couldn't find file "<Drive>:\<Path>\<filename>."
where '<Drive>:\<Path>\<filename> refer to the Access 7.0 database.
Windows NT
----------
Couldn't find file "<Drive>:\<Path>\<filename>."
Not a valid file name.
In either case above, after you click OK, you get a Login dialog box which
prompts you for a password. No matter what password you type, you still
cannot insert or attach the database.
These errors do not occur if you use DDE to insert or attach the database.
CAUSE
The Microsoft Access database is located in a folder whose name contains
an apostrophe.
STATUS
Microsoft has confirmed this to be a problem in Word versions 7.0 and 7.0a
for Windows. This problem has been corrected in Word 97 for Windows.
WORKAROUND
To work around the problem, choose one of the following methods:
Method 1:
When you get the Login dialog box described in the Symptoms
section, do the following:
- Click the Database button.
- In the Select Database dialog box, select the database, and
click OK.
- In the Login dialog box, click OK.
- Click the Insert Data button.
- Select the records you want to insert and click OK.
Method 2:
Insert the Microsoft Access 7.0 database using DDE instead of
ODBC.
Method 3:
Move the file to a folder or path that does not contain an
apostrophe.
Additional query words: 7.0 error datasource data source winnt word7 word95 winword
Keywords: kbinterop KB148121