Hi Lalit,
SYMPTOMS
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:
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.
For Further Information : Microsoft Knowledge Base Article - 121646
Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
