Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Access 2000 can I determine where the start range of a autonumber field can be set?
3 replies
by cptomlly
Just add a record with a value of x-1 for the autonumber field, where x is the value you want to start with, and then delete it. (This will have to be done with an append query, and then a delete query) Future autonumber values will start with x and increment.
Just a word of warning though, its not usually a good idea to use autonumber to represent any really significant values.
Hope this is what you needed.
by dliby
Thanks for the help.
by dliby
This question was closed by the author
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending
0 helpful
13 replies
Question
Is WSL still relevant in 2026?
0 helpful
1 reply
0 helpful
2 replies
0 helpful
10 replies
Question Unanswered
i need help in transferring my bulk emlx files
0 helpful
0 replies