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 Walt,

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

Cindy

Dear Walt,

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

Cindy

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.

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?

I do have an idea...one second!

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!!!

the tilde ~ acts as an enter key and is required in the sendkeys parameter to send the name of the database to the acCmdRepairDatabase

http://download.microsoft.com/download/access2000/Utility/1.0/WIN98Me/EN-US/JetCU40.exe
http://www.experts-exchange.com/Databases/MS_Access/Q_20027846.html
http://www.experts-exchange.com/Databases/MS_Access/Q_20087055.html

Please refer to ahove information.

Regards

Ben

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?

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

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

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?

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

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.

I have tried all the above but none works... anyone have any ideas??

If you create a new database, create 1 blank form and re-open it you don't get the error right?

"re-open it" <--- the new database

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

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.

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??

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

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

Robert

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.

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

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.

"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??

HaydnH:  see  http://www.experts-exchange.com/Databases/MS_Access/Q_20771544.html

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

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

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

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

Also try reinstalling your DAO if this doesn't work.