June 1st, 2005 06:47 AM
repairing .mdb file
recently bumped across a problem and after googling it alot, i decided to share it with AO. I recovered an accedently deleted database (Microsoft Access .mdb file) by using a third party tool GET DATA BACK. I was able to rcover it completely, but when i tried to open the recovered file, it said "unrecognised format". I tried to fix it with the help of bulit in compact and repair utility in MS Access but the problem presisted. I tried to fix it through JET utils, but still the problem is there. I have completely recoverd the database file but i am unable to open it. Any guidance for that would be appreciated.
My OS is Windows XP professional and the filesystem is FAT 32.
June 1st, 2005 07:38 AM
Then apparently you failed to recover it completely.
I was able to rcover it completely, but when i tried to open the recovered file, it said "unrecognised format"
What does the vendor, guessing getdataback, have to say?
" And maddest of all, to see life as it is and not as it should be" --Miguel Cervantes
June 1st, 2005 07:46 AM
Is it possible that, along with the .mdb file, there is an associated index file? I am only guessing here as I have very little experience with access, but many databases use more than one file for a databse.
But somebody should know, in any case.
Government is like fire - a handy servant, but a dangerous master - George Washington
Government is not reason, it is not eloquence - it is force. - George Washington.
Join the UnError
June 1st, 2005 09:53 AM
I'm not sure about more recent versions of Access but all that was required in the past was the .mdb, (the indexes were held within that too).
If you are getting the unrecognized format message then your database is almost certainly damaged beyond repair. It only needs a small amount of damage to offset the entire database and make it unreadable.
Don\'t SYN us.... We\'ll SYN you.....
\"A nation that draws too broad a difference between its scholars and its warriors will have its thinking done by cowards, and its fighting done by fools.\" - Thucydides
June 1st, 2005 02:06 PM
I have used GetDataBack for a while and it is a good program for recovering accidently deleted files. If the drive has been formatted and written over, then chances go down from there.
There is other data recovery software out there, but if the file or a portion of it is damaged then I doubt you will get it. You can spend big bucks if you want and send it to one of those big data centers. They charge alot though.
June 1st, 2005 02:14 PM
With Access version matters too..
Make sure you have the same version of Access that the database was in.
I have this problem with 97, 2000 access.
97 cannot read the 2000 version...and comes up with that error
see if you can try and read it with Crystal reports.
And make sure your AV is disabled from scanning .MDB files.
Also the database may link to another database....so you maynot have all the files.
How people treat you is their karma- how you react is yours-Wayne Dyer
June 5th, 2005 03:01 AM
You can try Recover My Files, i once recovered 10Gb for a friend of an acidental format.
there are several options of recover, you could try with "format Recover", i belive that he will try to recover sector to sector..
June 5th, 2005 01:16 PM
Striek wins a cookie!..................there were .mda and .mdb files.
I think that "da" stands for "data application" and "db" for "database"
Now these two are indexed and cross related, so what you need to do is re-build that relationship, as it is obviously broken.
It would be best if you tried with a "clean" recovered version, rather than one you have messed with. Also you may now have to go and recover the xxxx.mda component as well. At least get the two files together in the same folder.
Please let us know the version of Access you are using.
If you cannot do someone any good: don't do them any harm....
As long as you did this to one of these, the least of my little ones............you did it unto Me.
What profiteth a man if he gains the entire World at the expense of his immortal soul?