repairing .mdb file
Results 1 to 8 of 8

Thread: repairing .mdb file

  1. #1
    Senior Member
    Join Date
    Jun 2003
    Posts
    142

    repairing .mdb file

    hello AO,
    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.

    Thanx
    Ommy

  2. #2
    Senior Member IKnowNot's Avatar
    Join Date
    Jan 2003
    Posts
    792
    I was able to rcover it completely, but when i tried to open the recovered file, it said "unrecognised format"
    Then apparently you failed to recover it completely.

    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

  3. #3
    Senior Member
    Join Date
    Oct 2002
    Posts
    1,130
    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 community!

  4. #4
    AO Ancient: Team Leader
    Join Date
    Oct 2002
    Posts
    5,197
    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

  5. #5
    Member
    Join Date
    Mar 2004
    Posts
    81
    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.

    good luck

    ~Halv

  6. #6
    AOs Resident Troll
    Join Date
    Nov 2003
    Posts
    3,152
    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

    Just thoughts.

    MLF

    Edit

    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

  7. #7
    Senior Member
    Join Date
    Apr 2005
    Posts
    123
    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..

    Good luck

  8. #8
    Super Moderator: GMT Zone nihil's Avatar
    Join Date
    Jul 2003
    Location
    United Kingdom: Bridlington
    Posts
    17,190
    Hi,

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •