Lost # one ID

[gpal]

I have somehow lost the #1 in the ID field in an Access 2007 table I am working on. It now starts with with #2 and in numerical order from there. How do I add the # one back?
Thanks in advance.

 

[G37Sam]

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

 

[Galaxiom]

Restore the backup and link to the table. Then use an append query to add the record to the current table.

Unfortunately the Autonumber may try to continue again from 2. If so, copy the table structure and insert all the records into it. Then delete the old table and rename the new one.

 

[gpal]

Thank You for your reply