[AccessD] Autonumber in replication

Don,

Each of the FEs will need a local table holding the next available
sequence number for that FE that you then append to a unique id for that
FE and send that along to the BE as the test case number and show to the
user.  So Bubba's test cases would be BUBB0001, BUBB0002, etc. while
John's would be JOHN001, JOHN0002, etc.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Don Elliker [mailto:delliker at hotmail.com] 
Sent: Wednesday 2003 Aug 13 15:03
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