Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    york, Yorkshire, England
    Posts
    30
    Thanks
    0
    Thanked 1 Time in 1 Post

    access97 data loss (97 sr2)

    one of my access users did the following:

    filled in a form
    clicked on the Save icon
    left access open, but in a locked office
    came back 2 hours later and discovered that the last record they had entered had dissappeared and the form was blank.

    the database is shared, but both users *swear* they did nothing to account for the records apparent deletion.

    i know very little about the mechanics of access. has anyone out there encountered this problem?

    thanx
    john

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: access97 data loss (97 sr2)

    I've never heard of anything like that happening before.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: access97 data loss (97 sr2)

    Is there any kind of timer operating? It's possible to force an undo on a record if there hasn't been any activity for a set period of time, but that would have to be built into the code or operating from an add-in utility. Otherwise, this sounds highly unlikely. Of course, if one of my users went off and left a form up in edit mode for two hours like that, I would hunt them down and explain the problem ... with a large club most likely.

    Is it possible that their network connection dropped momentarily? No, scratch that question. Then they would probably have come back to a disk or network error message.
    Charlotte

Posting Permissions

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