dcsimg
Results 1 to 2 of 2
  1. #1

    Thread Starter
    New Member SarahJohnston's Avatar
    Join Date
    May 2018
    Posts
    1

    Post Something strange happened when working in MS Access.

    While working on the Access database, a power failure occurred and the file closed unexpectedly. However, the last actions were not saved - the backup worked, but not completely. Is it possible to do something about this. I don't want to redo the work again. I hope for your help.

  2. #2
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    6,697

    Re: Something strange happened when working in MS Access.

    Welcome to the forum.

    It's hard to answer your question with the info you've given.

    the backup worked, but not completely
    You'd really have to specify what "Not Completely" means. Id expect a backup to work or not. If it was only half backed up then, to all intents and purposes, it's not backed up at all. If anything, I'd expect it to be corrupt and unusable.


    Broadly, you can restore any successful backup which will restore your database to the exact point in time that the backup was taken. Any work carried out after that point won't be available and would have to be repeated. I can't imagine how any work that hadn't been saved would be recoverable as it wouldn't have been in the dbf file to be backed up in the first place.

    Sorry, I think that's probably not the news you wanted to hear.

    Edit> Wait, by "backup" are you referring to the autosave feature where access maintains a recover file - similar to Word, Excel etc? If so, I'm afraid the news still isn't good. Allowing it to recover from that will restore to the point it last autosaved but any work you did after that point would be lost.
    Last edited by FunkyDexter; May 18th, 2018 at 03:47 AM.
    You can depend upon the Americans to do the right thing. But only after they have exhausted every other possibility - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width