Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create Duplicate Values In The Index Message? (a2k (9.0.3821) SR-1 Jet 4.0)

    Create Duplicate Values In The Index Message?
    a2k (9.0.3821) SR-1 Jet 4.0

    A table has gotten into a condition where if I add a new record I get the following message:

    The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. OK

    Note: You can see the autonumber Key (9781) being assigned to the new record with a number lower than the previous/highest autonumber (15601) on the screen thus causing the duplicate autonumber value.

    This has happen several times over the past six months.

    My procedure to fix is:

    1. Import problem table into a new DB
    2. Delete problem table from production DB
    3. Import problem table from new DB back into production DB

    How can I troubleshoot why the problem table in being corrupted on auotnumber?

    Thanks, John

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

    Re: Create Duplicate Values In The Index Message? (a2k (9.0.3821) SR-1 Jet

    The only time I ever saw this kind of behavior in A2k was prior to SR-1, where appending records, including the autonumber value, to a table did not change the seed of the autonumber and so the system kept trying to assign a number one higher than the value assigned to the last record actually entered. The problem was fixed in SR-1, so is it possible that your SR-1 isn't all there? <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> What jet service pack do you have installed?
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create Duplicate Values In The Index Message? (a2k (9.0.3821) SR-1 Jet

    Hi Charlotte

    The computer in question is not mine. When I get on site next week I will check customers computer.

    If customer dosen't have access to the internet and/or www.microsoftupdate.com, how can I download on my Win XP computer, Jet Service Pack 7.exe for Win 2003 Server so I can hand carry it to my customer site?

    Thanks, John

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

    Re: Create Duplicate Values In The Index Message? (a2k (9.0.3821) SR-1 Jet

    <P ID="edit" class=small>(Edited by charlotte on 13-Oct-03 18:56. Added download link)</P>For Win 2003 Server? Has that already been released? I have no idea. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> Do you have access to MSDN Universal or TechNet Plus? The service packs for 2003 should be included there.

    Here's a link I tracked down to the download: http://www.microsoft.com/downloads/details...05-1d50559d6b83
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create Duplicate Values In The Index Message? (a2k (9.0.3821) SR-1 Jet

    Great detective work Charlotte!

    Thanks, John

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create Duplicate Values In The Index Message? (a2k (9.0.3821) SR-1 Jet

    Hi Charlotte

    Additional info on autonumber for your refrence at:

    http://members.iinet.net.au/~allenbrowne/ser-40.html

    I simply installed Jet SP7 and waiting to see what happens

    John

    (Edited by HansV to activate URL - see <!help=19>Help 19<!/help>)

Posting Permissions

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