McKirahan wrote:This is a frequently-asked question in the Access newsgroups (where it> I'm using MS-Access and was wondering if there's a way to DELETE a
> table and reset the primary key which is an AutoNumber field.
> If I do "DELETE FROM table_name" then all the rows are removed but the
> AutoNumber isn't initialized; thus, the next the AutoNumber field
> after the next INSERT is not 1.
> Thanks in advance.
should have been asked <grin>)
The easiest way is to compact the database after the deletion..
Another way is to change the field to Number and back to AutoNumber.
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.