Skip to main content

AddToAny

Share/Save

How to reset AutoNumber in MS-Access

No replies
sam
sam's picture
User offline. Last seen 1 year 49 weeks ago. Offline
Joined: 08/22/2009

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.