Haslett, Andrew
andrew.haslett at ilc.gov.au
Wed Aug 13 16:45:40 CDT 2003
>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.