I got an error 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. "

The SQL statement is:
string UserProjectPSQL = "INSERT INTO UserProject (UserID, ";
UserProjectPSQL += @"ProjectID, CreateDate) ";
UserProjectPSQL += @"VALUES (" +UserID+ ", " +intProjectID+ ", ";
UserProjectPSQL += @"'" +DateTime.Now.ToString()+ "')";

The UserProject table contains UserID as PK(Duplicates OK), ProjectID as PK(Duplicates OK), CreatedDate, and UserTypeCode. So, those values should be OK with duplicate values. How can I change the UPDATE statement?

Thanks,

Is this database Access?

By 'UserID as PK(Duplicates OK), ProjectID as PK(Duplicates OK)' do you mean the User ID and ProjectID are together a primary key? If so, then by definition, a primary key cannot have duplicates, despite what Access might have led you to think you may have set the column(s) to be.

If a column or columns are a primary key, then they are the unique means to identify a given row, so duplciates cannot be allowed, otherwise how would you know which one row the key referred to?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks!!!