Solved

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

Posted on 2008-10-27
8
1,970 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
  • 4
  • 4
8 Comments
 
LVL 18

Expert Comment

by:jmoss111
Comment Utility
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
Comment Utility
0
 
LVL 2

Author Comment

by:mrables
Comment Utility
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
 
LVL 18

Expert Comment

by:jmoss111
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 2

Author Comment

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

Author Comment

by:mrables
Comment Utility
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
Comment Utility
The data in the DATABASE, I meant, not the "table".
0
 
LVL 18

Expert Comment

by:jmoss111
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now