Charlotte Foust
cfoust at infostatsystems.com
Wed Aug 13 14:48:18 CDT 2003
The only sure way is to make the autonumber a GUID, which you do by selecting Replication ID from the FieldSize property. It's a bit more complicated to work with GUIDs though because you can't just compare them to each other. Charlotte Foust -----Original Message----- From: Don Elliker [mailto:delliker at hotmail.com] Sent: Wednesday, August 13, 2003 11:42 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