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."
And if all else fails, then your last resort (or sooner) is to contact Wayne @
http://www.everythingaccess.com/accessdatabaserepair_info.asp
mx
http://www.everythingaccess.com/accessdatabaserepair_info.asp
mx
ASKER
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.
<<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.
Your down to a recovery service then or a recent backup assuming that directory and file security is set for read/write.
Jim.
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.
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.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<<I was able to open the database in openoffice >>
Wow.
Make sure you accept your own comment as answer!
Jim.
Wow.
Make sure you accept your own comment as answer!
Jim.
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.
I have also had minor success with opening databases in newer/older Access versions as long as the jet/ace version was compatible.
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.
Find it amazing that Open Office opened it when Access itself would not.
Jim.
Could be kind of embarrassing for Microsoft :-)
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.
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.
ASKER
resolved issue
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.