 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / July 2007Out of control Autonumber
Can someone tell me why my Autonumber which started with 5 digits all of the sudden is going to seven digits and not in succession? It even has negative numbers.! It sounds like you expect some specific behavior from Access Autonumber. Autonumber is primarily intended to provide a unique (if arbitrary) row identitier. It really isn't suitable for human consumption. Acces Autonumbers are not guaranteed to be successive. They can be negative. Regards Jeff Boyce Microsoft Office/Access MVP > Can someone tell me why my Autonumber which started with 5 digits all of > the > sudden is going to seven digits and not in succession? It even has > negative > numbers.! >Can someone tell me why my Autonumber which started with 5 digits all of the >sudden is going to seven digits and not in succession? It even has negative >numbers.! Did you Replicate your database? or did you (perhaps unintentionally) change the Increment property of the autonumber to Random (replicating will do this to you)? John W. Vinson [MVP] Come to think of it, I did replicate it. The only thing is the database name doesn't show it as a replica or master but it does have extra fields in it that the help says are fields from replication. And I noticed I cannot add fields to tables created prior to doing this. I can add new tables and add to those but not with prior tables. How can I overcome this? > >Can someone tell me why my Autonumber which started with 5 digits all of the > >sudden is going to seven digits and not in succession? It even has negative [quoted text clipped - 5 lines] > > John W. Vinson [MVP] >Come to think of it, I did replicate it. The only thing is the database name >doesn't show it as a replica or master but it does have extra fields in it >that the help says are fields from replication. And I noticed I cannot add >fields to tables created prior to doing this. I can add new tables and add to >those but not with prior tables. >How can I overcome this? Restore your unreplicated backup from before you replicated... or google for "unreplicate". It can be done but it's a REAL chore. John W. Vinson [MVP] >>Come to think of it, I did replicate it. The only thing is the >>database name doesn't show it as a replica or master but it does [quoted text clipped - 5 lines] > Restore your unreplicated backup from before you replicated... or > google for "unreplicate". It can be done but it's a REAL chore. Er, not really. You unreplicate and then create new tables without the replication fields and append the old data. And there are tools to help out with that. See #10 here: http://www.dfenton.com/DFA/Replication/index.php?title=FAQ  SignatureDavid W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ > Can someone tell me why my Autonumber which started with 5 digits all > of the sudden is going to seven digits and not in succession? It even > has negative numbers.! I suggest you may not want to use Autonumber for that use. Autonumbers are designed to provide unique numbers. It in not designed to provide numbers in order and for a number of reasons may not do so. As a result using them in any application where the user sees the numbers is likely to end up with confusion. There are other ways of providing the numbers you want depending on the particual application. SignatureJoseph Meehan Dia 's Muire duit Thanks guys. I am definitely going to follow the link and work on this. By the way, how did you get this good? The knowledge you have. Are there any good schools or books out there? > Can someone tell me why my Autonumber which started with 5 digits all of the > sudden is going to seven digits and not in succession? It even has negative > numbers.! ?Years of painful experience?<g> Jeff Boyce Microsoft Office/Access MVP > Thanks guys. I am definitely going to follow the link and work on this. > By [quoted text clipped - 6 lines] >> negative >> numbers.! Gotcha!! Can you suggest some fine reading materials with exercises to practice? > ?Years of painful experience?<g> > [quoted text clipped - 11 lines] > >> negative > >> numbers.! >Gotcha!! Can you suggest some fine reading materials with exercises to >practice? Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials John W. Vinson [MVP] You guys are terrific! Thanks for the info! > >Gotcha!! Can you suggest some fine reading materials with exercises to > >practice? [quoted text clipped - 12 lines] > > John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.