Solved

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

Posted on 2008-10-27
8
1,977 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

861 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