Database Replication

[TorrediPisa]

Good Morning to Everyone

I have heard about the database replication but apparently there is not much informations about it.
I know this is a procedere to make a database replicated in another copy so that if a field of the db is modified, the same field is modified in the replica as well.
On Internet I found out a simple procedure to do so as follows:

open the db exclusive
click Create Replica from Replication from Tools Menu
click yes to close the current db
click yes to create a backup
select location of New Replica in a dialog box.

(So far I have duly followed the above tutorials, but from now on I do not understand how to do. The tutorial continues with:
click the "Priority Button"
type the "Priority" for the replica
click Ok
check the "Preventes Deletes" checkBox if you do not want users to delete records in the replica
select the "Replica Visibility" from the Save As Type box.

Well I cannot find any of the above buttons or checkboxes.
(I have Access 2000)
Pls kindly explain me in few words how to do that.

Very grateful for Yr time and attention
Best Regards

TdP

 

[willir]

There are intermediate and advanced books on Access that devote a chapter on the issue. Also, Access Help has info. Probably a white paper or two at Microsoft.

Before you start - backup your database.
Sequential autonumber will not work properly on transaction tables - you will end up with conflicts. Access will change these to "random" autonumbers. Or you can change them to guid numbers.
Have a good idea on how you will...
- update the data
- distribute updates
- contingency plans, if something goes wrong

Realize that you have one master replica and the rest are "slaves". Protect your master replica - backups again.

Consider other alternatives that have less maintenance, and probably less problems - terminal server / citrix server (these cost more).

Richard

 

[LittleSmudge]

And be careful want you read elsewhere.

The term REPLICATION means something completely different in SQL Server.

I mean, its only 'the other' database product from the same vendor - so why on earth should we expect the same term to mean the same thing ?



Arrrh!




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.