 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Replication / May 2004Autonumbers random
When I enter data from both my replica and master, the autonumber fields are completely random (as far as i can tell: -1010384 then 4838221 for example). Does anyone know why this would happen or at least how to resolve it? Thanks! Evan McCutchen evan AT radiologyonesource DOT com That's how replication works. Autonumber values are random, to minimize the likelihood of a value being used by multiple copies. It shouldn't matter, though. Autonumbers exist for the sole purpose of providing an (almost guaranteed) unique value that can be used for a primary key. -1010384, 4838221, 30, -603632 does that just as well as 3, 4, 5, 6. Seldom, if ever, should your users even be aware of the value of the Autonumber field.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > When I enter data from both my replica and master, the autonumber fields are > completely random (as far as i can tell: -1010384 then 4838221 for example). [quoted text clipped - 3 lines] > Evan McCutchen > evan AT radiologyonesource DOT com Doug, Okay, that makes complete sense. We are using the autonumber fields for things like quote numbers when customers call in about products that we have, though. Is there some way that you know of that we can get a sequencial number using replication? Or is there another way for us to approach our issue? We are opening a new office in europe and need them to have access to the same db that we have here in the states. Any input will be appreciated! Evan McCutchen evan AT radiologyonesource.com > That's how replication works. Autonumber values are random, to minimize the > likelihood of a value being used by multiple copies. [quoted text clipped - 15 lines] > > Evan McCutchen > > evan AT radiologyonesource DOT com There's no way to have Autonumbers be sequential with replication. End of story, I'm afraid. You'll have to come up with your own approach, such as having a table that contains the last number used and look it up there. Of course, if your numbers have to be unique across the multiple locations, you'll have to have some way of knowing where you are. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Doug, > [quoted text clipped - 30 lines] > > > Evan McCutchen > > > evan AT radiologyonesource DOT com alrighty, doug. Thanks for your assistance! Evan McCutchen evan AT radiologyonesource DOT com > There's no way to have Autonumbers be sequential with replication. End of > story, I'm afraid. [quoted text clipped - 40 lines] > > > > Evan McCutchen > > > > evan AT radiologyonesource DOT com As a workaround, convert it to HEX instead with the Hex() function -- you will get something alphanumeric that they will probably digest as easily as any such random number. SignatureMichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no rights. > alrighty, doug. Thanks for your assistance! > [quoted text clipped - 49 lines] > > > > > Evan McCutchen > > > > > evan AT radiologyonesource DOT com |
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
|
©2008 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.