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

    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
    out on a limb
    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