Tables :: How To Recreate AutoNumber Column With Values Assigned

I am using a form based on a table in MS Access 2010 for data entry.

The Data Type for column ID is AutoNumber with Increment=1. When I found ID for recent entries gets an anomaly (e.g. should be ... 3, 4, 5 ..., but it shows ... 3, 5, 6 ... that misses 4), I tried to refresh/change the ID column with the following steps:

1). Change the Data Type for column ID from AutoNumber to Number
2). Add a new column IDD and set its Data Type as AutoNumber
3). Delete the original column ID
4). Change column name IDD into column name ID

However, I got a problem with step 2): here the order # for the records becomes messed up, e.g.

Should be:
ID IDD
1 1
2 2
3 3
5 4
6 5
7 6
... ...

But, I got:
ID IDD
1 3
2 4
3 5
5 1
6 2
7 6
... ...

Why? Is this caused by the relationships between this table and other tables?