Hi,

This is geeta. I have taken access as a dataBase with Asp.net Application. I have taken two text type fields in employeeDetails table These are

Field Name DateType

 EmployeeId Text (Primery Key)

  password Text

Then When i am inserting unique & notNull values in Login form. Then a error occur With detail

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.
What should i do. Suggest me please

geeta

I'm sure you are a aware of this; but your primary key can not have duplicate values.
Since your employeeID is your primary key you won't be able to have two duplicate employeeId values.

Definition: The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person) or it can be generated by the DBMS (such as a globally unique identifier, or GUID, in Microsoft SQL Server). - http://databases.about.com/cs/admini...primarykey.htm

If you have any additional relationships or indexes please post them.

- A.Kahtava