SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Mar 2005
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    duplicate values in the index, primary key, or relationship problem

    Hi

    I have a membership application on my site, running off Access database with asp. It has been working fine, made a couple of changes and now all kinds of trouble have broken loose!

    I have even re-uploaded original files back up, but I am still getting the below error:

    "Microsoft JET Database Engine error '80004005'

    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.

    /login/user.asp, line 345"

    This happens when I new user tries to register, thus when info is to be sent to the database.

    The page is here http://www.saltrock.com/login/user.asp

    Help appreciated

    Matt

  2. #2
    SitePoint Addict
    Join Date
    Feb 2004
    Location
    Staffordshire, UK & Florida, USA
    Posts
    314
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    As the error messages implies, you either have a primary key or other unique index which prevents you from storing a row which would violate this by having duplicate data.

    Check that you are not submitting fields which have values identical to any of the primary/unique keys in your database table, e.g. same ID number or username or e-mail (depending on what columns are in your table and which have primary or unique keys.

    If you are still having problems try posting the schema for the database and/or your SQL insert query.

    Hope this helps.

  3. #3
    SitePoint Member
    Join Date
    Mar 2005
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks djones, will take a look!


Bookmarks

Posting Permissions

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