Re: Replication - GUID:s....
From: Vitalijus J. Karalius (vjk_at_nospam.pls)
Date: 01/02/05
- Next message: Ritesh: "Comparetive study DAO v/s JRO"
- Previous message: Cheval: "Re: Replace a replica"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 2 Jan 2005 12:58:24 +0200
http://www.mvps.org/access/general/gen0025.htm
http://www.trigeminal.com/usenet/usenet011.asp?1033
"Andreas Andreasson" <andreas.andreasson@telia.com> wrote in message
news:AnFAd.12427$d5.107838@newsb.telia.net...
> 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
>
>
- Next message: Ritesh: "Comparetive study DAO v/s JRO"
- Previous message: Cheval: "Re: Replace a replica"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
