Don't write (that's to say INSERT) the first page records to the database if nothing has changed. This will mean you need to have hidden fields containing the original (key) data so that you can see if anything has changed but should solve your problem.
Andy -------Original Message------- From: [email protected] Date: 01/10/05 23:23:31 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 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 the Yahoo! Terms of Service. ---------- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.9 - Release Date: 06/01/2005 [Non-text portions of this message have been removed] 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/
