Results 1 to 9 of 9
  1. #1
    Join Date
    May 2006
    Posts
    386

    Unanswered: Can a file (Front End DB) that was deleted from Netwok be recovered?

    Dear All,

    Just a few minutes ago, one of my colleaguges was entering some data on the database when she got an error that the datase encountered some problem and had to shut down. So she clicked OK and when I tried to open the database for her again (please note the same database (front end) was already open on other computers) it could not open it as it was not able to link to the backend tables. I noticed that in the same folder another file was created 1db.mbd and I deleted that file as in the past usually when the Datase gave the same error it created a similar file and when I deleted it without encountering any problem. So when I deleted this new file 1db.mbd somehow the actual Front End database got deleted from the network and I am unable to recover the Front End. I searched the recycle bin etc on all computers but could not find it.

    I download a recovery software and it found a file but am not sure if it is the same but when I try to open that it gives me this error message " Unrecognized database format.

    Anyhelpe would be greatly appreciated.
    Last edited by Emal; 07-27-09 at 11:52.
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Sep 2008
    Location
    NM, USA
    Posts
    97

    Red face Just a story.

    This sounds really similar to something that happens to me in Excel sometimes.

    Once, I was working with a report in Excel, or Word or something, and all of a sudden the program shot me the bird and closed. All that remained was a .tmp file.

    And when I tried to restore it, MS Office just laughed at me. All I can think to tell you is "back to the ol' drawing board."
    "Unix is user friendly... It's just very picky about its friends."

    The best things in life...are well-documented.

  3. #3
    Join Date
    May 2006
    Posts
    386
    Yeah, I am extremely stressed and hope that someone would be kind enough to sympathize and help me find this front end. i tried many data recovery software but no joy. I have an older version ( 1 year old) copy of the same front end but when i try to open it it gives me an error saying "Uncrecognized Database format" i tried to run Compact and Repair but it wont open and work.
    Emi-UK
    Love begets Love, Help Begets Help

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    3rd topic the same.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    May 2006
    Posts
    386
    Hi StarTrekker,
    My sincerest appologies, yes, I was trying to edit some information but didnt realise it created a duplicate. but the second one is slightly different as I am still working to figure out a solution. In fact, I managed to find an older version (1 year old) of the Front End but when I try to open it gives me the Message saying "Unrecognized Database format. I tried Compact and Repair it did not work, I created a blank db in the same folder and ran Compact and Repair on and then did the same on the older version (1 year old but corrupted one) but it did not work.

    Anyhelp would be extremely appreciated. I am stressed out with the whole sudden loss of the Front End. Thank you so much for any help.
    Emi-UK
    Love begets Love, Help Begets Help

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Are you sure the backup is the same Access file format version? As I suggested in the other topic, the backup may be in something like Access 97 format.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Sep 2008
    Location
    NM, USA
    Posts
    97
    I'm sitting here trying to imagine exactly what could have failed so epically in your database that it obliterated the entire front end.... I seem to recall you saying that it had produced this error and created the 1db.mbd file on multiple occasions before, which you routinely deleted without incident...but this time was different and poooof everything goes bye-bye.

    Do you have any idea at all why your database was doing that to begin with?

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    What amazes me is that this front end was being used by users and was the ONLY recent copy. Sorry, but that is just asking for trouble.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    May 2006
    Posts
    386
    Hi, Yes it has been a very costly and painful lesson learned. I should have created a front end for each user. I dont know why I was getting the same error in the past as well but somehow when I or my colleagues were trying to raise an invoice sometimes it gave that error but I always noticed that after giving that error another file called "db1.mbd" not 1db.mdb (my apologies) was created, I always deleted that file and then opened the database again and it worked but this time the whole Front End is disappeared.

    StarTrekker, yes, i never had an older version than 2000. the current version is 2002.
    Emi-UK
    Love begets Love, Help Begets Help

Posting Permissions

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