[AccessD] "Faked" replication

Hello All,

This might sound ridiculous...but could each user Replicate...and prior to 
the replication, create say 1000 blank records in the master for said 
user...the ID would be created in the master therefore unique...they could 
then do whatever data entry they needed only up to the number of blanks 
acquired at replication...and the db could warn them when they are running 
low on blanks...

It might be duct tape and bailing wire...just thought I'd share.

Thanks,

Mark


>From: Gustav Brock <gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] "Faked" replication
>Date: Thu, 18 Dec 2003 16:08:01 +0100
>
>Hi Susan
>
>Oh, you are about to confuse me ...
>
>Steve talked about collecting data from 15 locations.
>You wrote about "uniqueness across many systems"
>And MS is quoted for suggesting that "GUID datatype is definitely the
>way to go" in such a situation.
>
>Then you conclude:
>
> >> > Microsoft recommends that you not use GUID's as primary keys ..
>
>How does that match?
>
>/gustav
>
>
> >> Ehh, Susan ... aren't you (re)reading your own articles too fast:
> >>
> >> <quote>
> >>
> >> Microsoft discourages the use of GUID as a primary key, but that's
> >> because most people don't really need universal uniqueness. When
> >> uniqueness across many systems is vital, however, the GUID datatype is
> >> definitely the way to go. Just remember that you pay a price in
> >> performance.
> >>
> >> </quote>
> >>
> >> Isn't "across many systems" exactly the situation of Steve?
>
> > =============I don't really understand your question? Do you think the
> > statement is wrong? FWIW, I'm not suggesting the article solves anyone's
> > problem. Just linking because it discusses the subject. Arthur may pipe 
>in
> > here later.
>
> >> /gustav
> >>
> >> PS: Nice picture of you and your mother!
>
> > =============Thanks. :) Remember the pic of Ann Landers that was a 
>bazillion
> > years old? Well, she's not the only one that can pull that trick. BTW,
> > that's actually my granddaughter. :)
>
>Perfect! Do I feel lucky?
>
>/gustav
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
It’s our best dial-up Internet access offer: 6 months @$9.95/month. Get it 
now!  http://join.msn.com/?page=dept/dialup