[AccessD] Custom autonumbers and replication

The ADH has a bit on using a custom autonumber in place of Autonumber which 
I want to use for tables involved in replication. What I don't get is, if 
the replication scheme does not include the database where the new 
autonumbers are kept (The idea is to have tables stored in a separate 
database wherin only the next autonumber is manipulated for each table. The 
requesting function calls with the table name, locks it , gets the 'next' 
value, increments by 1 and frees up the table for the next user.) so OK, 
swell, sounds good..but , if these 'autonumber' tables reside in a database 
not in the Replication scheme....what is the benefit? How will I connect to 
it? From each database separately to the common autonumber 
database?........I think I must be missing something. I have used 
replication before , but never with this kind of a key (autonumber or a 
single field, unique number)
-As an added bonus,I cannot use prefix/ identifiers like TED001 for Ted's 
stuff , etc. I don't know if I can seed the individual master tables (which 
get the majority of the updates) with a value sufficiently distant from one 
another, or ,have them increment in odds or evens...(going nuts now)

Any Replication smarties out there???


"Things are only free to the extent that you don't pay for them".-Don 
Elliker

_________________________________________________________________
Get MSN 8 and enjoy automatic e-mail virus protection.    
http://join.msn.com/?page=features/virus