Skip to main content

AddToAny

Share/Save

Database Design

How to reset AutoNumber in MS-Access

I am working on a desktop application, where I am using MS-Access as backend. I generally use AutoNumber as a primary key.

I want to reset the AutoNumber to its initial seed, which is '1'. I have search a lot about this, but fail to reset it.

This seems to be a very simple question, but frankly speaking I dont have any prior experience of Ms-Access. I have been working on sqlserver for most of my projects.

Please Help. Thanks in Advance.

Syndicate content