I used the code on Page 81 of the book "ASP 3.0 Programmer's Reference" from Wrox and the procedure on pp 84-86 and tested my page for duplicate primary field entries. When I clicked the Save button on my page, instead of the customized page, I still get the following :-

Microsoft JET Database Engine error '80004005'

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.

/hardware/_ScriptLibrary/Recordset.ASP, line 311


I used Visual Interdev 6 Enterprise and DTCs for my page. I have Windows 2000 Server & IIS.

What is wrong here?

Regards,

Mark