Solved

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

Posted on 2008-10-27
8
1,975 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
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
 
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

920 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

17 Experts available now in Live!

Get 1:1 Help Now