I'm no expert but it sounds like your database field for this particular information is defined as "no duplicates" at least that's what I gather from your message. Are you able to access the database to change the field definitions?
Bob -----Original Message----- From: klrclark [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 4:48 PM To: [email protected] Subject: [AspClassicAnyQuestionIsOk] New to ASP - Inherited ASP system Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [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. /DOCS/EmployeeData_TEST/AddHpersonal_info.asp, line 13 How can I not write to the DB when the record is in there but there are still other fields that need to be completed on the next page? Thanks Karen Yahoo! Groups Links --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.830 / Virus Database: 565 - Release Date: 1/6/2005 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.830 / Virus Database: 565 - Release Date: 1/6/2005 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
