ACC: "Couldn't Find Object" Err with 1.x DB in 2.0, 95, 97

• Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

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

When you open a Microsoft Access version 1.x database in Microsoft Access 97, Microsoft Access 7.0, or Microsoft Access 2.0, you may receive the following error message:

   Couldn't find object '<database.mdb>'

   -or-

   The Microsoft Jet database engine could not find the object
   <objectname>.

   Make sure the object exists and that you spell its name and the path
   name correctly. (Error 3011)

   -or-

   Couldn't find object '<object name>'

CAUSE

There is at least one database object with a backquote character (`) in its name in the version 1.x database. The backquote character, which is ASCII character 96, is not allowed in object names in Microsoft Access 97, 7.0, or 2.0. The backquote character is allowed in object names in Microsoft Access 1.x.

RESOLUTION

Open the database in Microsoft Access 1.x and rename any object that contains a backquote character in its name before opening the database in Microsoft Access 97, 7.0 or 2.0.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97 and Microsoft Access versions 7.0 and 2.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it become available.

MORE INFORMATION

The error messages mentioned earlier in this article can occur at different times, depending on which object's name contains the backquote character.

• If a module's name contains the backquote character, you will receive the following error message.

  In Microsoft Access 97:

        The Microsoft Jet database engine could not find the object
        <objectname>.
  

        Make sure the object exists and that you spell its name and the path
        name correctly. (Error 3011), then followed by the following error
        message:
  

        The current user account doesn't have permissions to convert or
        enable this database.
  

  In Microsoft Access version 7.0:

        "Couldn't find object '<database.mdb>'" error message when you open
        the database, then followed by error message:
  

        The current user account doesn't have permission to convert or enable
        this database.
  

        At this point you are unable to open the database.
  

  In Microsoft Access version 2.0:

        "Couldn't find object '<database.mdb>'" error message when you open
        the database, then followed by error message:
  

        Database <database name> was created by a previous version of
        Microsoft Access.  You won't be able to save changes made to object
        definitions in this database.
  

        However, the database will open.
  

• If the first table in the Database window contains a backquote character in its name, you will receive the following error message.

  In Microsoft Access 97:

        The Microsoft Jet database engine could not find the object
        <objectname>.
  

        Make sure the object exists and that you spell its name and the path
        name correctly. (Error 3011)
  

  followed by the following error message:

        The current user account doesn't have permissions to convert or
        enable this database.
  

  In Microsoft Access version 7.0:

        Couldn't find object <object name>'
  

  twice, followed by the following error message:

        The current user account doesn't have permissions to convert or
        enable this database.
  

  At this point, the database will not open.

  In Microsoft Access version 2.0:

        Database <database name> was created in a previous version of
        Microsoft Access. You won't be able to save changes made to object
        definitions in this database"
  

  followed by the message:

        Couldn't find object '<object name>'
  

  twice when you open the database.

REFERENCES