Myo wrote:
Hi all!
I've replicated my Access DB using briefcase in winXP. All Autonumber
PK changed to random number. They were increment b4. Fortunately i
could recover it through my backup. I just want to know if there's
anyway to replicate the tables without letting the windows to change
my design? Thanks in advance..
First the golden rule of AutoNumber: The User Doesn't See it!
After observing that rule it's easy to work out that increment or
random, it doesn't matter, computers aren't fussy, as long as it's
unique is all it cares about.
IOW if your number is supposed to mean something to a human, don't use
AutoNumber. If you need an incrementing number you should roll your own
(plenty of examples in the google archive).
Your problem will be from using multiple sites all wanting an
incrementing number, it would be quite slow if a satellite site was t
oconnect to the main site to get the next number so you need another method.
The way I do for multiple warehouse receipt numbers is
WarehouseNo/Increment, if you must have only one series of numbers you
could pool them, IOW when satellite connects to main to replicate you
also then look at the number pool and take say if you expect 10
transactions before next replication take 15 numbers minus the number of
numbers you had left over from last replication.
--
\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\