REPLICA QUESTIONS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DREAMER - 14 Jul 2006 02:03 GMT

Hello,

I have created only one REPLICA of one MDB (that has only tables) with Access XP and have distributed 10 COPIES of same (Copy and paste) to the different ones PCs in differents cities .....

QUESTIONS:

1 - When it synchronizes the 10 copies (that in fact are the same one, but copied) with the main design, I can experience some problem?

2 - When each one of those REPLICAS generate his ID, it can happen that different registries are superposed, erasing data of another synchronization?

I hope understand my questions.

Thanks!

Dreamer. -

Reply to this Message

David W. Fenton - 14 Jul 2006 12:54 GMT

> I have created only one REPLICA of one MDB (that has only tables)
> with Access XP and have distributed 10 COPIES of same (Copy and
[quoted text clipped - 5 lines]
> one, but copied) with the main design, I can experience some
> problem?

No, they are not the same. They have the same data and the same
design, but as soon as they are opened, they are no longer
identical, because each will get a new, unique ReplicaID.

> 2 - When each one of those REPLICAS generate his ID, it can happen
> that different registries are superposed, erasing data of another
> synchronization?

Eh?

A ReplicaID is a GUID, which, as the name implies, is globally
unique. It is calculated from machine-specific data and from the
time it is created and cannot collide with another GUID generated
elsewhere.

The assignment of ReplicaIDs is not something you can control, and
it's not something you should worry about.

What you've done so far is just fine. Now you have to figure out how
to synch between the replicas, in-place. That means indirect
replication, as only a LAN is sufficiently fast and reliable to
support direct replication (i.e., the kind of replication you get
from the Access user interface).

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

DREAMER - 16 Jul 2006 01:32 GMT

Hello David, thanks for reply!

I even have left doubts

1 - which the best way is of synchronizing the you reply (being that you reply them they were created as he/she commented in the previous questions)?

2 - having used the tools characteristic of access originally; what is it more advisable?; To use same Access for the synchronization?; or the one "replication manager?"; Which is the appropriate way of using them in my case?

Thanks a lot!

Dreamer .-

PS: Sorry for my english

--------------------------------------------------------------------------------

>> I have created only one REPLICA of one MDB (that has only tables)
>> with Access XP and have distributed 10 COPIES of same (Copy and
[quoted text clipped - 29 lines]
> support direct replication (i.e., the kind of replication you get
> from the Access user interface).

Reply to this Message

David W. Fenton - 16 Jul 2006 02:19 GMT

> 1 - which the best way is of synchronizing the you reply (being
> that you reply them they were created as he/she commented in the
> previous questions)?

The best synch method depends on the connection present. If all
replicas are accessible to each other over a LAN, or if you only
want to synch when connected to a LAN, direct replication will work.

If you need to synch over dialup, over the Internet, over a wireless
connection or over a WAN, then you need to use indirect replication.

> 2 - having used the tools characteristic of access originally;
> what is it more advisable?; To use same Access for the
> synchronization?; or the one "replication manager?"; Which is the
> appropriate way of using them in my case?

Replication manager is not really an end-user tool, in my opinion. I
would program the synch into the user application so that the users
only have to click a button or choose something from a menu.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message