Autonumber reset + Access 2010

[dougancil]

I have a user who had deleted some records from a database today using Access 2010. They have an ID field that's autonumbered. They have No Duplicates allowed. When they created a new record today, it was recreating numbers that had already been assigned but deleted. I've read a couple of articles about resetting the autonumber in Access, but I'm wondering if this is the only way to really fix this issue? Has anyone else came up with a work around for this? I've seen some people using a script to work around it. Any suggestions would be appreciated.

Thank you

Doug

[ADezii]

What exactly are you looking for, Doug? Do you wish to wish to start the numbering all over again, making the IDs Unique and Sequential as in: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,...NNNNN?

[dougancil]

I think what this was, was a problem with Access 2010. The user copied the file from a server to their laptop and replaced the file in question back on the server and autonumbering started working again. I guess this is the same as resetting Autonumbering.