?
Solved

Database will not open

Posted on 2014-07-17
8
Medium Priority
?
230 Views
Last Modified: 2014-08-05
We have a Access 2010 Database application distributed to users in the field.  One user is now unable to open it and retrieve his data.  Is receiving the followintg message "The Microsoft Access database engine could not find the object 'Databases'.  Make sure the object exists and that you spell it's name and the path correctly.  If 'Databases' is not a local object, check your network connection or contact the server administrator.

According to user this is not used on a network, not used in anytype of cloud or shared environment.  Tried to open a new database and import objects, could not do that either.
0
Comment
Question by:Leslie_G
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 1500 total points
ID: 40202690
Have you been able to open the database yourself?

It seems like the DB is corrupted.

Try compact and repair and see if that helps.

Could also be that the version you are using is not compatible with the server you are saving your database on.
0
 

Author Comment

by:Leslie_G
ID: 40202734
Made a copy of the corrupted database. Downloaded jet Engine and tried to repair the copy, but the Jet Engine blew up the file and it disappeared. Made another copy of the database. Downloaded Microsoft Workbench and tried a repair. Still won't work. He can open older Edit List Generator databases, just not this one. He has Access 2013 32-bit installed. Running Windows 8.
0
 
LVL 29

Expert Comment

by:sammySeltzer
ID: 40202763
All you would need to do is open the database if it lets you, click on Database Tools.

Then click on Compact and Repair.

That's it.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Leslie_G
ID: 40202792
When I open the database it will not let me do that.  It opens with the error message and when I click OK, it just closes the dB again.
0
 
LVL 29

Expert Comment

by:sammySeltzer
ID: 40202833
That database is toast, I am afraid.

If you have a backup copy of it ( and I hope you do), then you could get a COPY of that backup copy and use that instead.
0
 

Author Comment

by:Leslie_G
ID: 40202846
Unfortunately I don't think that the user created a back-up (user is not me).  Our field offices use these as stand alone applications that email purchase requests to our home office.  We don't have much control over what happens after they download them from our intranet. Thanks for your suggestions anyway.  I was hoping someone had somethint I hadn't tried.
0
 
LVL 85
ID: 40203358
Anoter suggestion would be to try a Decompile, although I think you're out of luck.

To try that, MAKE ANOTHER COPY and then create a Desktop shortcut with a Target like this:

"full path to msaccess.exe" "full path to the database" /decompile

Run that, then try to open it again. If it works, you should immediately make a back of THAT database.

You might also try to import everything into a new, blank database (although I doubt that will work either).

If all else fails, and if it's worth saving, you could try www.everythingaccess.com - they have a repair service that can sometimes resolve issues like this.
0
 

Author Comment

by:Leslie_G
ID: 40242112
Thanks for everyone's help - unfortunately I believe that the database was corrupted and unrecoverable after trying all solutions.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

770 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