Hi, Don't know if you've resolved the problem. Without you showing the code, it's hard to guess what the fix is. If you code is building an "insert tablexxx (field1, field2 ... ) values ( 1 , 2 ... ) then you cannot add a record with the same key info as one that already exists. Take a look at the table you are inserting into with Access and see if the record is already there. You may also need to create a index or primary key if there is no one defined ( but since you inherited the system it's probably there ).
If you show the code which builds the statement and you can answer the question on what primary keys or indexes you have on the table then we can help you. Another option to allow someone to remotely control you're desktop ... to troubleshoot for you. GetSmartPaul On Tue, 11 Jan 2005 21:49:26 -0000, klrclark <[EMAIL PROTECTED]> wrote: > > > how do I do this? I'm new to ASP matter of fact I've done very > little programming in it. > > --- In [email protected], "Andy.T" > <[EMAIL PROTECTED]> wrote: > > 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 > > > > > 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/
