I just started getting this error in one of my SQLServer 6.5 db's. I don't know what could be causing it. The primarykey/identity column is named FolderID. Why would it be trying to insert a duplicate if it's an autonumber? ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK__Folders__FolderI__198AD3B0': Attempt to insert duplicate key in object 'Folders'. SQL = "INSERT INTO Folders ( ParentID, Name, Description, ateAdded )VALUES( 7, 'test', 'test', {ts '2000-10-04 12:27:18'} );" Thanks. Ric Smith ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.