Learn The Secrets Of Customising An Autonumber Primary Key In Access

Have you ever wanted to customise an autonumber primary key in an Access table? For example if you delete some records from a table, the auto numbers originally used by the deleted records are not used again, so there are gaps in the primary key numbers. You might then want to reorganise the primary key with successive numbers. Or suppose you want to have a primary starting at a different number, for example 100, you might wonder how to do this. This articles shows you how to restore an autonumber list so there are no missing numbers, and also shows you how to make a custom autonumber list.

The full article appears here:
http://www.microsofttraining.net/article-1261-learn-secrets-customising-autonumber-primary-key-in-access.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com