duplicate values in the index, primary key, or relationship problem
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.
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.