Solved

MS Access 2003- The Microsoft Jet database engine could not find the object 'MSysDb'.

Posted on 2008-10-27
8
1,979 Views
Last Modified: 2010-07-27
Serious Problem:

Our Access 2003 database, for reasons very much so unknown to me, is reporting the error:

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

I do have backups of the database available, but it changes significantly day-to-day, and that information needs to be recovered.  I've tried several recommended solutions, compact and repair, MSQuery, JetComp, and several different attempts to access the records and simply import those into the database backup, with no luck.  

Thank you very much for your help.  Any suggestions are appreciated.  
0
Comment
Question by:mrables
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 18

Expert Comment

by:jmoss111
ID: 22818048
Hello mrables,

Have you tried opening an empty db and importing all the objects one by one and checking that you can open the imported ones before continuing to the next object?



Regards,

Jim
0
 
LVL 18

Accepted Solution

by:
jmoss111 earned 360 total points
ID: 22818118
0
 
LVL 2

Author Comment

by:mrables
ID: 22818298
I have tried the database recovery tools and, while they work, I cannot spend the money to purchase them.  How would I go about importing the objects one by one?  I have tried opening a blank database and importing the broken one, but it failed with the same message.

Thank you very much.

-Mr. Ables
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 18

Expert Comment

by:jmoss111
ID: 22818380
Do the import just like you did except do it for one object at a time, check to see if you can open and then continue to next object.

Are all your objects in one db, IE data tables, queries, forms, reports, etc?
0
 
LVL 2

Author Comment

by:mrables
ID: 22844839
Correct, all of the objects are in one database, that cannot be opened.
0
 
LVL 2

Author Comment

by:mrables
ID: 22844881
It seems that the data in the table is more corrupted than I had assumed.

The files from the day that I need are completely missing, along with about 1/3 of the rest of the data.  I cannot seem to find any reason for this either, the logs tell me nothing.  While it is alarming, we can redo the data from the missing day and input it into the backup from the day after.  If that backup was not available, there would be huge problems.

Moral of the story for anyone who works in the IT field (and I think anyone who has any experience in the field knows this very well): always backup your important data.  If it is updated daily, it should be backed up daily.

Thank you jmoss111 for your assistance.
0
 
LVL 2

Author Comment

by:mrables
ID: 22844887
The data in the DATABASE, I meant, not the "table".
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 22845266
You can either live or die by backups; i've been in IT for well over 30 years and got my discipline in highly structured belt, suspenders, and a rope around the belt mentality datacenters.

You're welcome; glad that I could assist.

Jim
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question