I get a duplicate index error message when I insert a record through VBA into a table. The table has nearly 1345 records. The same code had worked fine earlier and also works fine now with a blank copy of the same table. I understand that it is not an issue with the code or the data inserted. Can someone help whether there is any constraint with the number of records. The table has no autonumber field.