>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).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com