I'm writing a C# application with an Access database behind it, and I stumbled upon something I can't figure out: one of my table's Primary Keys is in AutoNumber format, and I would like the auto-number to start from whatever the last number present is. It does not do that (it starts from whatever the last number EVER present was...).

For example:

Table contains:

1 - stuff
2 - more stuff
3 - even more stuff

If I delete record 3, then add another record, the table looks like this:

1 - stuff
2 - more stuff
4 - new stuff

rather than

1 - stuff
2 - more stuff
3 - new stuff

I can't even figure out how to reset the auto-number count from within Access, let alone from my code...

Anyone have any suggestions?

I realize that I could get rid of the AutoNumber type and programmatically take care of the numbering - it seems to me like there should be a simple and effective solution to reset the AutoNumber, though...

Thanks!