has anyone come across this error message and how to correct it. i get this after cart page and before final confirmation page.

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.
/ic_proj/checkout1.asp, line 91


with regards
salman.

That is a problem with your database. Somehow, the data being written to the DB has a duplicate entry, which your table field is rejecting because it has one of two properties... It is the primary key (which cannot allow duplicates) or it is set up to be unique.

In my experience anyway.

Check the fields of your update form.
There might be two fields having same name.

This may help:

www.macromedia.com/support/ultradev/ts/documents/insert_into.htm