How to Reset the Number of AutoNumber field on Table

How to Reset the ID of AutoNumber field on Table Per picture below, a Customer table has a Customer_ID field as a primary key and its data type is set to AutoNumber. That means the Customer_ID is automatically assigned by MS Access to each record and it is incremented by one (1). The first record will start with one on the Customer_ID field. If we delete some records then the next Customer_ID will continue from the one that is deleted. For some reasons that you want to start the Customer_ID…

Read More