Problem in charon cart UpdateUser.asp

For those which are familiar with charon cart.
Fact: A customer updates to another CustomerEmail.
When he updates and the CustomerEmail is already exist in the Customer tabel
the follow error occurs,

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.

UpdateUser.asp, line 148

The error line comes from:

143 If (Not MM_abortEdit) Then
144 ' execute the update
145 Set MM_editCmd = Server.CreateObject("ADODB.Command")
146 MM_editCmd.ActiveConnection = MM_editConnection
147 MM_editCmd.CommandText = MM_editQuery
148 MM_editCmd.Execute
149 MM_editCmd.ActiveConnection.Close

(The NewUser.asp detects if the CustomerEmail already used by another
customer, but the UpdateUser.asp don't detect it. So it's possible two
customers have the same email).

How can I bypass this situation by returning to UpdateUser.asp so the
customer can fill in another unique Email?

Thanks,
Herman

Look in the database under Tools > Relationships. And delete any enforced
relationships.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004