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
Solved

Database will not open

Posted on 2014-07-17
8
227 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
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.

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

861 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