Can't Insert Access 7 Database if Path Contains Apostrophe

• Microsoft Word for Windows 95, versions 7.0, 7.0a

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>."

   -or-

   Not a valid file name.

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:

          a. Click the Database button.

          b. In the Select Database dialog box, select the database, and
             click OK.

          c. In the Login dialog box, click OK.

          d. Click the Insert Data button.

          e. Select the records you want to insert and click OK.

          ODBC.

          apostrophe.