Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Posts
    369
    Thanks
    2
    Thanked 1 Time in 1 Post

    Previous operation cancelled disaster recovery (2000 SR 1a)

    I have noticed that when access gives you the option to save multiple objects, and you deselect one or more, this often leads to problems, not sure why.

    today, however, the problem is a disaster, as I am getting persistent "You cancelled the last operation" errors on opening the database or trying to do pretty much anything with it, after selecting not to save my changes to module 1.

    I have tried msaccess.exe /decompile "c:database name", but just get the error messages again. Oh, and before I did this I tried compiling and compacting and repairing. Each action generated the error and failed to solve it. Help! Oh, and compiling generates a module not found error after 4 cancelled operation errors, but the text of module 1 is still there and unchanged from before the aborted save.

    I've also tried exporting, removing and importing module 1, with and without repairing and compiling in the process, to no avail.

    The db contains over 20 tables, 50 queries, 30 forms and 10 reports, with some tables in the 10's of megabytes, so I really don't want to have to export everything, and even though I will lose a few hours work, it would probably be quicker to go to a backup, which I have (but it's still a few hours work).

    Thanks

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Posts
    369
    Thanks
    2
    Thanked 1 Time in 1 Post

    Phew

    Gulp!

    Found one post through google referring to a KB article (which I can't find), suggesting deleting everything that was changed before the save operation that created the problem - so only had to delete 2 forms and import from backup.

    My question is, though, given that access doesn't allow you to save things individually, how are you supposed to prevent this happening? Saving each and every change would be a complete pain, especially if changing the name of a variable (for instance) throughout a project.

    Anyone else had this problem?

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Phew

    No, I've never encountered the problem, and I've been working with Access since it was first introduced. I don't always save every new or changed object because I may throw those away so not saving is simpler than deleting. If the objects are permanent, then why would you not save them given the chance?
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Posts
    369
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Phew

    <center><img src=/w3timages/blackline.gif width=33% height=2></center>
    I don't always save every new or changed object because I may throw those away so not saving is simpler than deleting

    <center><img src=/w3timages/blackline.gif width=33% height=2></center>

    That's exactly the point - I can't seem to find a way to not save without causing chaos. Every time I want to save an object, the multiple object save dialogue box pops up, and if you deselect any object, that's when the trouble starts. It seems to be worst if you choose not to save changes to a module, but any form with attached code can cause it. I can't find any way to specifically save one object.

    BTW, does /decompile work with A2K SR1a? I couldn't seem to get it to do anything (it certainly didn't help).

    Sean

Posting Permissions

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