Tobi's right. Access actually adds a number of hidden/system fields to
each table and converts sequential autonumber fields to random number
(I think it is in Long Number format). I've used replicated databases
for years and have only had one problem. The databases need to be
syncronized regularly otherwise the replica becomes "aged" and Access
won't sync with it any more. I think the limit is about 1 month
(Anybody able to confirm the time limit for me?).
One other thing about relication is that you can only make design
changes to the Design Master (the original database). This helps avoid
users changing things on you. Also, should the Design Master become
corrupt, you can elevate one of the replicas to become the new Design
Master, almost a "built-in backup".
Hope it works well for you.
Paul
--- In AccessDevelopers@yahoogroups.com, "Jeanie S" <[EMAIL PROTECTED]>
wrote:
>
> Thanks for that info, Tobi. That eases my mind a little bit to know
> that the autonumbers will be random instead of sequential. Now I
> suppose it's time to test it out.
>
> Unless someone else has a reference for replicating that I can look
> at before I jump in.
>
> -- Jeanie
>
> --- In AccessDevelopers@yahoogroups.com, "Tobi Hoffman"
> [EMAIL PROTECTED]> wrote:
>
> When you go to a replicated database system, the Autonumber keys
> become random numbers rather than sequential, and with the number of
> digits used, it would be highly unlikely to have duplicate keys in
> the different replica databases. That being said, I have looked at,
> but have not yet used replicated databases, and would still prefer to
> use other means to pull in data to a master database. Anybody else
> out there with more experience using replication?!
>
> Tobi
>
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
