Question Strange behaviour first field (ID) table

[Jerome]

Hello,

I have some strange things going on in my table.

I have records 1 to 152 in my data table filled with data.

When I add a new record the ID starts with 54917764 instead of 153? Is there a way to initialize the ID this or is this a error?

Thanks in advance.

 

[boblarson]

Hello,

I have some strange things going on in my table.

I have records 1 to 152 in my data table filled with data.

When I add a new record the ID starts with 54917764 instead of 153? Is there a way to initialize the ID this or is this a error?

Thanks in advance.

Actually, it is working just as Autonumbers are intended to work. They provide a UNIQUE number, but they are not guaranteed to give you an incrementing number. Something has caused your autonumber to go into random mode and not be in incremental mode. But it really shouldn't matter as autonumbers should really be used by Access to manage records and their relationships and not for user viewable things. If you need user viewable numbers, you should look into using the DMax +1 code.

You can reseed your autonumber though. Do an Append Query that appends one record and feed the autonumber the number it would need for the next value. You can only append ONE record first and then after that it should be reset.