I have a table in an Access database with an autonumber field.
When I delete all the records from the table, the autonumber remembers the last number.
Does Access have something similar to SQL Server's TRUNCATE TABLE MyTbl?
If not, how to start with 1 after I delete the table's records?