Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Last record disappears (Access 2002)

    Here's a really strange problem: Overnight I lose the last record off of one table. Other tables that are related to that table do not lose related records. No other data in any other tables is missing (as far as I can tell so far). Any ideas?

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

    Re: Last record disappears (Access 2002)

    What exactly do you mean by "lose the last record"? How are the other tables related to that one? And where are you seeing this loss, in a query, in the table itself, or in a form or report?
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Probable solution

    Well, I think I found the problem with this. We found the records with the ID filed edited to another number. Apparently someone opend the form and started typing in a number to search for a record, then realized they were in a live record and went to filter by form, but left the text in the ID field. That made the record "disappear." Obvioulsy I have to fix that so it doesn't happen again.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Probable solution

    This is one of the reasons to use an AutoNumber field as (meaningless) ID - users can't edit it.

    BTW, if you turn on relational integrity with cascading updates for the relations of the table with other tables, changing the ID in the main table will cause the related field in related tables to change with it.

Posting Permissions

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