ACC: Error Converting Version 1.1 Database to 2.0, 95, 97

Last reviewed: May 7, 1997
Article ID: Q121472
The information in this article applies to:
  • Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you try to convert a Microsoft Access version 1.1 database to Microsoft Access 2.0, 7.0, or 97, and the database has a table with a field name that contains a backward apostrophe (`), you may receive the following error message:

   In Microsoft Access 97:

      "The Microsoft Jet database engine could not find the object '<Table
      Name>'. Make sure the object exists and that you spell its name and
      the path name correctly."

   In Microsoft Access 2.0 and 7.0:

      '<Database name>' is not a valid filename

CAUSE

A backward apostrophe is allowed in table field names in Microsoft Access version 1.1, but is not allowed in Microsoft Access 2.0, 7.0 and 97.

RESOLUTION

Remove the backwards apostrophe from the table in version 1.1 before you try to convert the database.

MORE INFORMATION

Steps to Reproduce Behavior

  1. In Microsoft Access version 1.1, create a new database. Name the database DB1.MDB.

  2. Create the following new table called Table1:

          Table: Table1
          ------------------
          Field Name: One`
          Data Type:  Text
    

    NOTE: The backward apostrophe is above the TAB key to the left of the number 1 key on most keyboards.)

  3. Quit Microsoft Access 1.1.

  4. Start Microsoft Access 2.0, 7.0 or 97 and convert the Microsoft Access 1.1 database:

    In Microsoft Access 7.0 or 97:

          a. On the Tools menu, point to Database Utilities, and then click
    
             Convert Database.
    
          b. Select the Db1.mdb database in the File Name box, and then click
             OK. Note that you receive the error.
    
       In Microsoft Access 2.0:
    
          a. On the File menu, click Convert Database.
    
          b. Select the DB1.MDB database in the File Name box, and click OK.
             Note that you receive the error.
    
    

REFERENCES

For more information about converting databases, type "convert database" in the Office Assistant, click Search, and then click to view "Convert a database."


Additional query words: conversion
Keywords : CnvNodb kberrmsg kbusage
Version : 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 7, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.