Problem with autonumber

[radek225]

When I tried paste some data using front end to my database, Access showed error (can't create record because data would be duplicated). I thought it's impossible because it is autonumber filed. So I checked it (manually). I did copy of my database and then for testing, I created record. I was shocked. Next record should has a value of "160" but Access gave "130" then showed an error "Can't create record because data will be duplicated". Of course after compact and repair everything is fine. But the question is, what could generate this situation?

 

[kevlray]

I am not sure, but some years ago I had to append some data to a table. I had to 'turn off' the auto-numbering, append the data (creating my own 'auto-number'), then turn the auto-number back on.

 

[radek225]

Microsoft Access does not allow turn it back (autonumber filed)

 

[kevlray]

It has been a long time since I did it. Maybe I imported the data into another table with the auto number turned off. Do remember the steps I took. I just remember it being a real nuisance.

 

[jdraw]

Read this article to better understand autonumbers

 

[Galaxiom]

Autonumber incrementing can fail after an insert. It often continues incrementing from the last inserted record instead of what is expected.