Can't Insert Access 7 Database if Path Contains Apostrophe (148121)
The information in this article applies to:
- Microsoft Word for Windows 95
- Microsoft Word for Windows 95 7.0a
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.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbinterop KB148121 |
|---|
|