Hi, Somewhere in your Access table definition you've defined a column, and it might not be the primary key, as requiring unique values. So you're going to need to check your table columns in Access and see which columns have the indexed value set to "yes - no duplicates" and change it to "yes - duplicates OK" or "no" not indexed.
HTH, t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ********************************************************************** -----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 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 error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:53). Date/Time: 02/04/02 13:39:38 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; msnca3; Q312461) Remote Address: 192.139.241.145 HTTP Referrer: http://127.0.0.1/test/admin/profiles/env_Add_Form.cfm ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
