Can I reset Primary Key to zero?

[Julianne]

I'm a newbie with Access databases (which I'm using with ASP to build web pages). To test if my pages were working properly I entered some dummy information into the database. I then deleted the records once I'd finished testing (by highlighting and clicking the Delete Record button) but now entering new information is showing the first record as 4 (I'd entered 3 dummy entries) when I want it to go back to 1!

Is there a way of setting the Primary Key back to zero so the first entry will be given the number 1, or do I have to start all over again and build a new table?

Many thanks.

Visit my ice hockey site at:

http://www.leevalleylions.co.uk

 

[mpastore]

I assume you are using an autonumber field for PK (which is good). Just compact the database after deleting records and you should start from 1 again.

Mike Pastore

Hats off to (Roy) Harper

 

[Julianne]

You assumed right and your answer works a treat - many thanks!

Visit my ice hockey site at:

http://www.leevalleylions.co.uk