Solved

Database will not open

Posted on 2014-07-17
8
223 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
  • 4
  • 3
8 Comments
 
LVL 28

Accepted Solution

by:
sammySeltzer earned 500 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 28

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
 

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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 28

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 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

14 Experts available now in Live!

Get 1:1 Help Now