Reset AutoNumber or RecordID number

[spectraflame]

Is it possible to reset the record ID number or autonumber that is automatically assisgned to each new record? I have been testing a database and would like to delete the junk records in the table and start over fresh with #1 if possible.

Thanks,
Matthew

 

[SydneyGeek]

You can make a copy of the table using Save As, and elect to save only the structure. You'll then need to delete the original relationships to the first table, delete the first table, rename the copy, and reinstate the relationships.

Denis