i am getting error

This topic is locked

i am getting error	5/5/2007 5:45:33 AM
ASPRunnerPro General questions
A azmi2 author i developed an application with ASP RUNNER.WHEN I AM ENTERING data it working fine,but when i enter same data it gives me error :i am using access database TABLE field name: ID,BLOOD_ID,BLOOD_TYPE_ID,QUANTITY,DATE,COMMENT I SELECT BLOOD_ID,BLOOD_TYPE_ID,DATE AND ID FOR PRIMARY KEY FOR DATA SHOULD NOT DUPLICATED I GOT FOLLOWING ERROR: error type: OLE DB provider for ODBC drivers (0x80040E2F) [MICROSOFT] [odbc microsoft access driver] row in error line no PLEASE HELP ME KAMALUDDIN AZMI


	Sergey Kornilov admin 5/7/2007
	It looks like your choice of key column is incorrect. I would recommend to add an Autonumber field to this table and use it as a key column.