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

    Unanswered: I have totally lost the Front End Database after it caused an error. Help please

    Dear Friends,
    I would be extremely grateful if anyone can help or guide me to the right direction.

    Today, one of my colleagues was entering data on a form on the Database when she got an error messaging saying the MS Access encountered and had to restart. So I closed the database and realised that in the same folder a new file called "1db.mdb" was created, as usual I deleted that file and tried to open the databse through the shortcut on the desktop but somehow the whole Front End has desapeared (deleted). I have tried many Data Recovery software but no joy, non found it.
    I had a very old backup which I am not sure whether this restored file has all the new forms, report etc but after I restored this file, when I try to open the file it says, Unrecognized database format. I tried to Run Compact and Repair and Tried to Convered the DB back to 2000 or 1997 but it does not allow me and gives the same message.

    I would be extremely grateful for any help and advice on how to fix this? For your information, the Front End was saved on one computer which serves as a server and other computers accessed the DB through a MapDrive.

    Thanking you so much.
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You deleted it over the network, bypassing the recycle bin, so there is no recovery that I am aware of, but to restore from a recent backup.

    If you have only a really old backup then all you can do is learn why backups are good and to actually bother to do them.

    The unrecognisable database format might be that the version you have restored is an Access 97 database and you're trying to run it in a later version of Access.

    You should also learn that having users running off the only version of the front end is just asking for trouble and it seems like you found it.

    I know this isn't the answer you want, but it's an answer.
    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

  3. #3
    Join Date
    May 2006
    Posts
    386
    Hi,
    Unfortunately, it has been the most painful and unpleasant lesson that I have learned and I am totally lost and very concerned that if I don’t get this issue fixed or not able to recover the Front End, it can lead to my dismissal from work and honestly, I am extremely stressed and it 3am in here but I am still struggling to find a solution.

    I would really appreciate any help or advice. I ran quite a few Recovery Software but no joy as none of them found the file. The only hope that I hope is someone to help me how to fix this older version. I tried to convert it back to 2000 as I know the older version was Access 2000 but it is now working and gives me the same message.
    Emi-UK
    Love begets Love, Help Begets Help

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You could try creating a new blank DB and import all the objects from your restored front end into it.
    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, I actually tried that but it gives me the same error as it cannot open it no matter how I try. I tried opening it by opening access it did not work, i created a new blank db and tried to import or even link but it did not work
    Emi-UK
    Love begets Love, Help Begets Help

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    well theres no polite way of saying this
    you haven't got a backup
    you don't know the origin of the year old file you think is a backup

    essentially you are stuffed with a capital F
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    May 2006
    Posts
    386
    Hi, well, it is a back up not very old and it will serve my purpose as almost everything will be in this backup but regretfully It does not open, it keeps giving message "unrecognized database format.
    Emi-UK
    Love begets Love, Help Begets Help

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Repeating the problem again won't help.

    Can you upload it? I can try to open it for you in all versions of access and see if any of them open it. Don't like the chances though, I think Healdem is right.

    Hard way to learn to make sure you have regular and reliable backups... a lesson I have been teaching for more than 15 years.
    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

Posting Permissions

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