By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Autonumber reset + Access 2010

100+
P: 347
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
Oct 29 '10 #1

✓ answered by 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.

Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,615
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?
Oct 30 '10 #2

100+
P: 347
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.
Nov 1 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.