[AccessD] Autonumber in replication

>From memory, when you create a replica it changes the primary keys to
'Random' or 'Replication ID' or something similar.

Cheers,
Andrew



-----Original Message-----
From: Don Elliker [mailto:delliker at hotmail.com]
Sent: Thursday, 14 August 2003 5:12 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Autonumber in replication


How do you all handle autonumber fields in replicated database schemas, so 
that the autonumber remains unique? I have this as a pending issue where a 
database tool is potentailly being rolled out to more users than a single BE

/multi FE setup would be good for. I have the primary key on the main driver

table set up as autonumber and I am trying to get my head around this 
concept as applied to replicated db.
_d


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

_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.