Solved

Database will not open

Posted on 2014-07-17
8
229 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 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 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

729 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