recover data from Access Database

I am at the least, trying to recover data from a Microsoft Access database that will not open. I am presuming that the issue is related to the database exceeding 2GB. The user was adding photographs to the database which is why it is so large. The user is not concerned about recovering the photos, just the other data. When trying to open the database I receive "Not a valid bookmark" pop-up twice and then does not open. When I try to run the Compact and Repair Database tool I get the error "The Microsoft Access database engine cannot open or write to file 'D:\....accdb.' It is already opened exclusively by another user, or you need permission to view and write its data."
italo5696Asked:
Who is Participating?
 
italo5696Author Commented:
I was able to open the database in openoffice and save the table without the pictures to a spreadsheet. thanks for the assistence.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
1. Make a copy of the database and put it in another directory.

2. Try opening the copy.

3. If you still receive an error, try a compact and repair on it.

Let us know where your at after that.

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
And if all else fails, then your last resort (or sooner) is to contact Wayne @
http://www.everythingaccess.com/accessdatabaserepair_info.asp

mx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
italo5696Author Commented:
Jim, I copied the database from the user's thumb drive to a disc, and then to my computer. So it is a copy. When I try to run the Compact and Repair Database tool I get the error "The Microsoft Access database engine cannot open or write to file 'D:\....accdb.' It is already opened exclusively by another user, or you need permission to view and write its data." There is no locked file though that I can see in windows explorer. Also, importing the data into a new database produces the "Invalid bookmark" error.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<So it is a copy. >>

 Your down to a recovery service then or a recent backup assuming that directory and file security is set for read/write.

Jim.
0
 
Glenn MadineSystems AnalystCommented:
Try creating a new blank database. Then open the new database and see if you can import all the forms/queries/tables from the corrupt database into your new blank database.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Seems like the database is pretty well trashed....he already tried the import trick and the fact that he's getting the "or you need permission to view and write its data" message would indicate that the ACL's on the database objects are messed up (assuming directory and file security is correct).

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I was able to open the database in openoffice >>

 Wow.

 Make sure you accept your own comment as answer!

Jim.
0
 
PatHartmanCommented:
Who knew?

I have also had minor success with opening databases in newer/older Access versions as long as the jet/ace version was compatible.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
JETCOMP.exe used to have some success as well, but it was never updated for the accdb format.  

  Find it amazing that Open Office opened it when Access itself would not.

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Could be kind of embarrassing for Microsoft :-)
0
 
Jeffrey CoachmanMIS LiasonCommented:
Yes,...here are always times when you get data in another forms (csv, DBF, ...etc), and Access will balk, ...but it will open fine in Excel.
But it is odd that Access would no open the file but OpenOffice would...

In any event, try the more accepted technique of "Linking" to images, instead of storing them in the database.
0
 
italo5696Author Commented:
resolved issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.