Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Unanswered: what might cause the autonumber to reset?

    i got to the 87th record and over the weekend the damn auto number reset to 20 causing duplicate primary keys Why?

  2. #2
    Join Date
    Aug 2002
    Location
    Québec, Canada
    Posts
    109
    Compact Datase can reset AutoNumber field. It is not suppose to create duplicate key (actually, it can't duplicate key in the same TABLE)

    JefB

  3. #3
    Join Date
    Nov 2001
    Posts
    336
    Hi,

    In order to fix the problem you need to obtain Microsoft Jet 4.0 Service Pack 4 (SP4) or later, which contains an updated version of the Microsoft Jet 4.0 database engine.

    More info available in MS Knowledge Base Article - Q257408:

    ACC2000: AutoNumber Field Duplicates Previous Values After You Compact and Repair a Database

    HTH, Igor

  4. #4
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    thanks, maybe it will fix the problem but i haven't compated/repaired this database, though i did do it to another very recently
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

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