Re: Replication - GUID:s....

From: Andreas Andreasson (andreas.andreasson_at_telia.com)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 21:32:16 GMT

Thank you so much for your answer! I find it very relevant for me. I have
used a lot of dlookup questions in my VB-code and I'm worried about using
this random autonumbers in the dlookup questions. I'm not sure how to make
my own unique numbers instaed of the autonumber series.

> To answer directly, it is not necessary to use GUID instead of
> counters.
>
> Background: If your tables use conventional (ie., incremental)
> Autonumbers as the primary key, then they will be converted to
> "random" autonumbers after applying replication. Accordingly, if you
> have used your primary key in a "meaningful" way before replication,
> then they will become less useful after replicaiton because of their
> random nature.
>
> However, it is strongly recommended to never use autonumbers in a
> "meaningful" way (e.g., invoice numbers, order numbers) because they
> are never guaranteed to remain sequential ("holes" may develop). You
> should always use your own method for creating identifiers such as
> invoice numbers.
>
>
>
>
> On Tue, 28 Dec 2004 21:53:28 GMT, "Andreas Andreasson"
> <andreas.andreasson@telia.com> wrote:
>
> >Hi all!
> >I have a newbiequestion about GUID:s. Is it necessary to use GUID instead
of
> >ordinary counter when you make the replication. I have problems with my
> >counters - long integer. The will not automatically count when I use the
> >replication method. I have not transformed the counter to GUID:s. Anybody
> >knows if it is necessary or recomended to change to GUID. I'm sorry about
my
> >English I'm from Sweden so English is not my nativelanguage.
> >
>
>
> **********************
> jackmacMACdonald@telusTELUS.net
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security

Relevant Pages

  • Re: Replication - GUID:s....
    ... > used a lot of dlookup questions in my VB-code and I'm worried about using ... > this random autonumbers in the dlookup questions. ...
    (microsoft.public.access.replication)
  • Re: Replication - GUID:s....
    ... >used a lot of dlookup questions in my VB-code and I'm worried about using ... >this random autonumbers in the dlookup questions. ... >> remove uppercase letters for true email ...
    (microsoft.public.access.replication)