[AccessD] Autonumber in replication

Another approach is to use a multiplicand to denote offices or whatever. I'm
not a big fan of this approach but in some circumstances it has merit. I.e.,
office 1 has PKs 1... 1,000,000, office 2 has PKs 2... 2,000,000 &c. The
upside is that you can scale the scheme to suit most future considerations.

A.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Don Elliker
Sent: Wednesday, August 13, 2003 4:03 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Autonumber in replication


Yes. I just found some info on this in the 2K/ADH - Vol2 page 472. Looks
like a custom assignment of this value is in the wings as JET changes the
assignment from sequential to random. Not good for my purposes....I can just
see my users face when their new test case is number 1,956,000,045. Come to
think of it, I WOULD like to see their face...And don't yell at me about
using autonumber in a visible way,etc. etc....I didn't do that part, it was
already like that when I got here..(yeah, sure it was buddy)...anywho,
thanks
_d