Autonumber Problem

[AP186]

I am not an Access user but I have created a basic database with an autonumber primary key within the table. Due to testing etc the autonumber has obviously incremented accordingly. Is there a simple way of resetting this value to zero/01

 

[HarleyQuinn]

If you do a search on this forum for 'reset autonumber' there are several methods that are explained in detail for you.

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations

 

[AP186]

My apologies....

Many Thanks

 

[HarleyQuinn]

No need for apologies, I just pointed you to the search as it is easier for you to view the prewritten solutions than for them to be re-written in this thread.

Cheers

Harleyquinn

---------------------------------
For tsunami relief donations

 

[ZmrAbdulla]

The simple solution is to delete all the records and compact & Repair database
TOOLS > DATABASE UTILITIES > COMPACT & REPAIR.
Also it'd be worth if you read these FAQs
[ul]
[li] Use of Autonumber faq702-5106 [/li]
[li] How can I auto-prefix my autonumber field? faq181-1725 [/li]
[li] Create a Autonumber with a Suffix faq181-1179[/li]
[li] How to autonumber date values in a control. faq181-1129 [/li]
[li] What can I use besides AutoNumber faq181-1023 [/li]
[li] Make an intelligent autonumber field? faq181-159 [/li]
[li] can I make a dynamic autonumber? faq181-158 [/li]
[/ul]


________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.