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.

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

For more information about naming conventions in Microsoft Access, search the Help Index for "naming database objects," or ask the Microsoft Access 97 Office Assistant.

Keywords : kberrmsg kbui UifOthr
Version : 2.0 7.0 97
Platform : WINDOWS
Issue type : kbbug