Results 1 to 5 of 5
  1. #1
    Join Date
    May 2015
    Posts
    1

    Answered: Access Database file "disappeared"

    Hello everyone!
    My Access MDB file has "disappeared" from his documents folder. I haven't deleted it, I have checked recycle bin, system restored, searched and so on. No luck!

    Any suggestions on what else I could do to recover the file?

  2. Best Answer
    Posted by OtelloP

    "
    Quote Originally Posted by IsaccoM View Post
    Hello everyone!
    My Access MDB file has "disappeared" from his documents folder. I haven't deleted it, I have checked recycle bin, system restored, searched and so on. No luck!

    Any suggestions on what else I could do to recover the file?
    First of all make a copy of your database FILE when ACCESS is not running.

    When an Access database file (mdb or accdb) is corrupt or damaged, then you can try several methods to repair and recover data from it:

    First of all, try compact & repair. Follow below STEPS:
    For Access 2010, click Compact and Repair Database on the Database Tools ribbon.

    For Access 2007, click the Office button (top left), then Manage.

    For Access 95 - 2003, choose Database Utilities from the Tools MENU.

    Second, if method 1 does not work then try to create a NEW Database and import all the objects from old database into new blank database.

    If nothing works, then you may use Access Fix Toolbox
    https://www.fixtoolbox.com/accessfix.html

    I hope i could help!"


  3. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    go back to your most recent back up, you do have backups, don't you?

    the file may have been moved so search your disk for it (use whatever search tool you feel comofrtable with. persoanlly I'd drop dwon to the shell and dir \filename*.* /s, but then again Im old school , aka pre historic)
    the file may have been renamed, may have a different extension, so that may cause a problem
    I'd rather be riding on the Tiger 800 or the Norton

  4. #3
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    If it is on his local PC, then that's a mystery why it vanished. (undelete?)
    and you searched the ENTIRE drive?

    I myself, make a backup copy of my db everyday. (just copy it to a different drive)
    Restore from backup. You DO back it up, right?

  5. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You might check Windows' Folder Options and see if 'Show Hidden Fields, Folders and Drives' is ticked; if not, tick it and look for the file again. Properties do get changed, from time to time, and as strange as it seems, it's more likely to happen than for a file to simply 'disappear!'

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #5
    Join Date
    Apr 2015
    Posts
    2
    Provided Answers: 2

    Access

    Quote Originally Posted by IsaccoM View Post
    Hello everyone!
    My Access MDB file has "disappeared" from his documents folder. I haven't deleted it, I have checked recycle bin, system restored, searched and so on. No luck!

    Any suggestions on what else I could do to recover the file?
    First of all make a copy of your database FILE when ACCESS is not running.

    When an Access database file (mdb or accdb) is corrupt or damaged, then you can try several methods to repair and recover data from it:

    First of all, try compact & repair. Follow below STEPS:
    For Access 2010, click Compact and Repair Database on the Database Tools ribbon.

    For Access 2007, click the Office button (top left), then Manage.

    For Access 95 - 2003, choose Database Utilities from the Tools MENU.

    Second, if method 1 does not work then try to create a NEW Database and import all the objects from old database into new blank database.

    If nothing works, then you may use Access Fix Toolbox
    https://www.fixtoolbox.com/accessfix.html

    I hope i could 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
  •