Means that a piece of data you're trying ton add to the database is the same as another piece of data that already exists in the database AND that is in a field that has it's index setting to "Yes (No Duplicates)".
HTH Lee Fuller Chief Technical Officer PrimeDNA / AAA Web Hosting Corporations -----Original Message----- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 11:14 AM To: CF-Talk Subject: Re: Inserting new fields into database... I keep getting this error when I try to insert new fields into my database. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

