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

[mattys]

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

 

[rodentcentre]

What type of primary key do you have on your table?? Is it an autocount, do you, through code, create a registration number, etc.?? Do you have another field indexed and have No Duplicates selected??