>before the deletion, the table contains no index, however i added one when i created the second one. It has a data field of number that increments automatically

That is the reason (missing index). ADO cannot find a key to update data if you don't have index (at least a primary key).