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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 Architect / Systems AnalystCommented:
And if all else fails, then your last resort (or sooner) is to contact Wayne @
http://www.everythingaccess.com/accessdatabaserepair_info.asp

mx
0
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
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 Architect / Systems AnalystCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.