I hope somebody will be able to help me. I inherited a complex application that uses ODBC as a storage for the client variables. The server is CF 4.0 on NT 4 box, running Access 97 databases (I know, upgrade is necessary, it is being looked into). The problem with the server is that it generates around 600-700 of the messages below per day: ==================================================== ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] 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. ==================================================== Has anybody encountered such a situation? Can anyone help me or direct me how to solve this problem?? Thanks, Dimo Michailov ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
