[AccessD] AccessD Digest, Vol 43, Issue 8

Stuart McLachlan stuart at lexacorp.com.pg
Sat Sep 9 17:16:53 CDT 2006


On 10 Sep 2006 at 8:03, Stuart McLachlan wrote:

> autoincrementing meaningful number.   In a replicated system, ANPKs are
> always "random numbering" and should generally be of type  "Replication ID"

I should have added:

You should however avoid ANPKs  whenever possible in replicated databases. 
They can cause a number of problems.  A common solution is to use a 
compound PK which comprises  an Autonumber field of type Long and  a unique 
ID which you assign to each replica (Company in your case).







-- 
Stuart





More information about the AccessD mailing list