Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    173

    Unanswered: A2003 - Table with AutoNumber Fields Getting Corrupted

    I have an issue that happenned a few times at seperate locations.

    A user is prevented from entering records in a table with an autonumber field.
    when the user tries to enter a record, a "duplicate key" error is generated.


    I looked at the table, and the autonumber field was being duplicated when anew record was entered...


    I solved the problem by replacing the table, which I thought to be corrupt.

    In the same application, at a different site, the same thing happenned to another table.


    What could cause this to happen?

    Thanks - AB

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Sounds like a bug report is required

Posting Permissions

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