replication manager

[Guest]

our server is w2k/exchange, workstations w2k w/office xp pro. We run a data base to track much information, currently the dB is located on the server and each workstation access and changes data to that database. Problem is performance...the database is slow. Contacted the creator of dB and suggested that perhaps replication would be the answer to the performance problem. They agree but indicate that I will need to purchase microsoft replication manager to controll the sincronization (sp???) of the various replicated sets. This will be fine but I cannot find any information concerning a replication (microsoft) manager for office 2002/2003

Question; is this product necessary to control the database sincronizations? If so, what is it called (named exactly) so I can price the product?

thanks in advance..............doug S

 

[Gary Miller]

Doug,

Replication Manager comes with the MS Office Developers
Edition. You can do replication without it, but you do
really want to have it if you are dealing with more than a
few replicas.

Beware, there are a lot of issues that affect performance
over the network that I would suggest investigating before
you go this path as replication is a bit of an art with
Access.

Some, but by no means all, of the issues are...

AutoCorrect issues.

Is the database split Front End local and Back End on the
server?

Antivirus scanning mdb files. This can apply to both local
and server AV programs.

Network cache settings

Connected recordset issues.

IMHO - It would be advisable to first focus on some of these
issues before you jump into Replication. You can probably
get some good leads by searching the group postings for
network performance posts or reposting with questions
regarding that.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message

our server is w2k/exchange, workstations w2k w/office xp

pro. We run a data base to track much information,
currently the dB is located on the server and each
workstation access and changes data to that database.
Problem is performance...the database is slow. Contacted
the creator of dB and suggested that perhaps replication
would be the answer to the performance problem. They agree
but indicate that I will need to purchase microsoft
replication manager to controll the sincronization (sp???)
of the various replicated sets. This will be fine but I
cannot find any information concerning a replication
(microsoft) manager for office 2002/2003.

Question; is this product necessary to control the

database sincronizations? If so, what is it called (named
exactly) so I can price the product?