Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HELP (2003)

    Perhaps records are being overwritten, rather than deleted.... it would explain why the autonumbers are consecutive.

    I'd add two fields to each of your tables, DateLastModified (Date field) and ModifiedBy (Text). When the record is modified, I would store the date/time and the user ID, which may be captured through VBA.Environ("UserName"). For selected fields I would write the date/time, user ID, old field value, and new field value to a text file. If files are being overwritten, they would show in this log file.

  2. #2
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    HELP: records disappearing (2003)

    Subject edited by HansV to be more descriptive than 'HELP'

    I doubt if anyone can really help on this one, but here goes. We have numerous databases on the network, and one by one people are reporting records missing. The databases themselves seem to be working. One has a weeks records missing (they have printed proof of these being entered), but the weird thing is, the log is autonumber, and the log numbers are consecutive. Even our IT department are at a loss as to what could have happened, so if anyone could suggest anything, it would be greatly appreciated.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: HELP: records disappearing (2003)

    Are you going back to look in the tables to see that the records are not there, are are they just not turning up in the forms and reports that users see.?
    Regards
    John



Posting Permissions

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