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

Dear all,

I am having the following erorr:

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

I cannot open my db now, how can I bypass the error and open the db?

Please help.

Thanks

Cindy
sushi97Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

walterecookCommented:
I would try holding down the Shift key while you open the db.  This bypasses any opening code and might give you a shot and getting in there and figuring out what's wrong.

Good luck
Walt
0
sushi97Author Commented:
Dear Walt,

This I have tried but didnt work.  Still same error message.  Any other suggestion?

Cindy
0
sushi97Author Commented:
Dear Walt,

This I have tried but didnt work.  Still same error message.  Any other suggestion?

Cindy
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

naivadCommented:
You can open a new database, and import all the objects from the old into the new....but it sounds to me like you need to compact and repair your database.
0
sushi97Author Commented:
Dear naivad,

I cannot compact & repair my db... it gives me the same error message.. as a result, I cannot import to a new db as well.

I really cannot Open it .. any clues?

0
naivadCommented:
I do have an idea...one second!
0
naivadCommented:
Create a new database...

Create a new form...put a button on the form...behind the click event...

Private Sub Command2_Click()
    SendKeys "db1.mdb~"    'the name of the database to be repaired
    DoCmd.RunCommand acCmdRepairDatabase    
End Sub


HOPE THIS WORKS!!!
0
naivadCommented:
the tilde ~ acts as an enter key and is required in the sendkeys parameter to send the name of the database to the acCmdRepairDatabase
0
sushi97Author Commented:
Dear naivad,

Thanks for your suggestion.. however...

I follow the exact steps of yours to create the form n button, but nothing happens when I click the button... whats wrong?  My code is:

Private Sub Command0_Click()
    SendKeys "c:\temp\testing\abc.mdb~"    
    DoCmd.RunCommand acCmdRepairDatabase
End Sub

Any clues?

0
Benjamin_LukCommented:
Try this :
in windows start menu put following command in run:
"MSAccess.exe""c:\temp\testing\abc.mdb" /compact

Please put your file path correctly. IF it can finish, please refer to my previous link information for you

Regards

Ben
0
rgcoleCommented:
sushi97,
"I cannot compact & repair my db... it gives me the same error message.. as a result, I cannot import to a new db as well."

Did you try this:
Create a new mdb file.
While in new mdb choose FILE --> GET EXTERNAL DATA --> IMPORT...
Select all the objects under each tab.
Choose OK to start the import.

Robert
0
sushi97Author Commented:
Dear Ben,

I have tried the JetComp but it said "Error compacting database"..
also running access using run command tried.. but same error message as open it normally..

any other ideas?

0
Benjamin_LukCommented:
Sushi97,

Final try,
use ODBC in control panel, click create new and then select Ms Access, select you database, please click repair it.

If it does not work, you need to pay some tool to recover it such as officerecovery,and others paid service most cost less than $100.

Please use code to backup your database and data

Regards

Ben
0
HaydnHCommented:
Starting a new database and importing the forms/reports etc is definately the way forward:

First create a new database and import all the items - open the database and see if the error occurs.

If that fails create a new database and move 5 items at a time before reopening to narrow down which lement is causing the problem.

Haydn.
0
sushi97Author Commented:
I have tried all the above but none works... anyone have any ideas??
0
HaydnHCommented:
If you create a new database, create 1 blank form and re-open it you don't get the error right?

0
HaydnHCommented:
"re-open it" <--- the new database
0
rgcoleCommented:
Is your db too big or too proprietary to prevent one of us from taking a stab at opening it?

You could attach and send to one of the participants (me or any other).

A last ditch effort.  My e-mail is in my profile area.

Robert
0
cbailCommented:
You can try this also: "MSAccess.exe""c:\temp\testing\abc.mdb" /decompile, although I doubt it will solve your problem.

I had the same thing happen to me. When I looked at the database in notepad, it was blank. There was nothing to salvage.

Access needs to be backep up everyday.
0
sushi97Author Commented:
Hi HaydnH / Robert

With a new DB, I can open n close without problems, however, when I try to import the corrupted db, the same error message pop up.  Have tried all the method suggested, but none can open it.  

I have tried the demo version of some access recovery tools, it did open it up but since it is demo, it only save 10 tables only.... however, it is too expensive for me to buy it.. :(

My db is only 110M which I dont think it is too big..

any help?? please??
0
rgcoleCommented:
Does the company that offers the recovery tool ALSO offer a service to repair a db?


Your db is 110 megs?  

How big is it if you zip?
Is it Access97, 2000?


Robert
0
rgcoleCommented:
I'm game to look at your db if it isn't too confidential.

Robert
0
sushi97Author Commented:
Dear Robert,

The company do offer service to repair but it cost more than USD200 since db size over 100M.

My db is in access 2000, try to use access 2002 to open it but failed..

After zip, its around 4M.

0
rgcoleCommented:
You have tried a zillion different ways and haven't had success.

I don't know if I have any magic here.

But, you can try to send to me for one last try.

my e-mail is in my profile.

Robert
0
jadedataMS Access Systems CreatorCommented:
sushi97:  When the error message comes up press {CTRL}{BREAK} (break is the pause key also)
I'm betting that there is code running on start up that has no error trapping.

{CTRL}{BREAK} will land you in the code on the line that is causing the error.  Fix it, or paste it here for a look by us alleged Experts.
0
HaydnHCommented:
"With a new DB, I can open n close without problems, however, when I try to import the corrupted db, the same error message pop up."

After importing how many tables/forms/reports does this happen? Does it happen just with the tables? with the tables and say 5 forms??
0
jadedataMS Access Systems CreatorCommented:
0
jadedataMS Access Systems CreatorCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ - no points refunded

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer
0
Computer101Commented:
PAQed - no points refunded (of 200)

Computer101
E-E Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
trinh78Commented:
Hi,

I experienced this problem before. When I tried to define object Database in VBA, but cannot. So, I go to Tools - References and choose "Microsoft Visual Basic for Application Extensibility 5.3". WOW, object "Database" appeared.
"Microsoft ... Extensibility 5.3" is a library that contains object Database etc...

Now, try it. I hope it will help you.

Bye,
Trinh
0
trinh78Commented:
Hello,

I am sorry. It's not "Microsoft Visual Basic ... ", please choose "Microsoft DAO 3.6 object library" instead. I would like to apologize to you. If you don't have DAO 3.6, you can try 3.5 or any version of DAO object. It works.

Again, sorry.

Hope it's useful.

Trinh
0
tciincCommented:
See this info.
http://support.microsoft.com/default.aspx?scid=kb;en-us;121646

Also try reinstalling your DAO if this doesn't work.
0
seyeu44Commented:
Use a Stellar Phoenix Access Recovery work fine to recover my database with this error!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.