Hi guys, i have some troubles with my database, i really need your help.

Let say i have a table with 10 records in it with an autonumber from 1 to 10. Now i want to insert a new record and i want make that record the second line.

So the point is increase record from 10 to 11, 9 to 10... and so on.. cause i don't want duplicate.

I already done this with VB6. It works however for some reason sometimes it doesn't.

My question is "Is there any way to do it automatically with Access". Increase auto from the insert record.

Thanks