AutoNumber

Hi Lucia

Please find a link below from Microsoft which explains how you can reset the autonumber field. I'm assuming this is a primary key. The link discusses steps for 2003 and 2007 and what to do if the primary key spans multiple tables.

YOU SHOULD BACK UP YOUR DATABASE BEFORE ATTEMPTING ANY STEPS IN THE ARTICLE BELOW


http://support.microsoft.com/kb/812718

Many thanks

Newson