Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AutoNumber Duplication (Access 2002)

    There are three users in an office I support who are entering data into an Access database. They are each using their own front end which is linked to the backend where the data resides. They have been using this same database for more than 5 years without any problem and now all of a sudden the autonumber field is duplicating numbers. I have tried compact and repair on the backend as well as on each person's front end and it is still continuing to happen. Could a virus cause something like this to happen?

    What steps should I take to fix this database?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

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

    Re: AutoNumber Duplication (Access 2002)

    According to AutoNumber field duplicates previous values after you compact and repair a database, you should install the latest Jet 4.0 service pack. The MSKB article contains a link to obtain the latest version.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutoNumber Duplication (Access 2002)

    Thank you. I have downloaded and installed the latest Jet 40 database engine for each of the users. Hopefully this will fix their problem.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: AutoNumber Duplication (Access 2002)

    Judy,

    You might want to check my website below for a utility that will reset the autonumber values on all tables in a database. The Jet patch doesn't fix the existing problem, it only keeps it from happening once the autonumbers have been correctly reset.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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