Solved

Database will not open

Posted on 2014-07-17
8
224 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

863 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

25 Experts available now in Live!

Get 1:1 Help Now