472,780 Members | 1,717 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,780 software developers and data experts.

Data Replication

Ray
Hi,

I have an Access 97 Database on the server, which gets updated from Desktops
thru a LAN. Employees who have to go to offsite locations, carry the latest
copy of the MDB. At the end-of-the day when they return to the office or
they send the copy of the MDB, the Laptop version (with their current
entries) has to be synchronized with the
MDB sitting on the server. How do I go about setting up this?

I would appreciate suggestions from anyone who has had experience in doing
this sort of a thing.

Thanking in Advance,

Ray
Nov 13 '05 #1
2 1733
"Ray" <No**************@Yahoo.com.HK> wrote in
news:2v*************@uni-berlin.de:
I have an Access 97 Database on the server, which gets updated
from Desktops thru a LAN. Employees who have to go to offsite
locations, carry the latest copy of the MDB. At the end-of-the day
when they return to the office or they send the copy of the MDB,
the Laptop version (with their current entries) has to be
synchronized with the MDB sitting on the server. How do I go
about setting up this?

I would appreciate suggestions from anyone who has had experience
in doing this sort of a thing.


Well, replication is OK in this scenario if your users connect
directly to the LAN. They can just open their local replicas on
their laptops and go to TOOLS | REPLICATION and synchronize with the
shared replica on the server.

A few points:

1. for anything other than a 10BaseT LAN connection or higher,
direct replication (i.e., through the Access menu) is probably fine.
It's not at *all* safe over any lower bandwidth or over a wireless
connection.

2. don't copy replicas around via the file system. Use them in place
on the laptops and synchronize when they are back in the office.
Once they are on the LAN, they can then use the shared replica on
the server. You say "or they send the copy of the MDB." That is
WRONG and will eventually lead to corruption of your replica set and
data loss.

Spend some time on http://www.trigeminal.com reading the replication
articles (which explain all of this) and then spend some time
reading the archives of microsoft.public.access.replication. You'll
see that 40% or more of the articles on that newsgroup are by
Michael Kaplan. Once you've read Michael's articles, you'll see that
this is A Good Thing.

Post back here with questions, or post them in the replication
newsgroup.

For what it's worth, I used to do lots of replication work, but now
prefer solving the same set of problems with Windows Terminal
Server, instead. Replication was simply too fragile for implementing
reliable data exchange in the kinds of environments my clients were
working in.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #2
Ray
David,

Thanks for your reply. As I am new to replication, I have a number of
queries for you.

1. The clients should synchronize their local replicas with shared
replica on the server. I believe they should synchronize with master design
database. Could you please give me some explanation about the meaning and
differences between shared replica and local replica.

2. ..don't copy replicas around via the file system. Since the master
design database cannot be moved to other area, the replicas must be moved to
the notebook computers in reality. How can we accomplish it?

Thanks for your suggested reading. I will spend sometime to read them all
in order to understand the replication in greater depth.

Ray
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.86...
"Ray" <No**************@Yahoo.com.HK> wrote in
news:2v*************@uni-berlin.de:
I have an Access 97 Database on the server, which gets updated
from Desktops thru a LAN. Employees who have to go to offsite
locations, carry the latest copy of the MDB. At the end-of-the day
when they return to the office or they send the copy of the MDB,
the Laptop version (with their current entries) has to be
synchronized with the MDB sitting on the server. How do I go
about setting up this?

I would appreciate suggestions from anyone who has had experience
in doing this sort of a thing.


Well, replication is OK in this scenario if your users connect
directly to the LAN. They can just open their local replicas on
their laptops and go to TOOLS | REPLICATION and synchronize with the
shared replica on the server.

A few points:

1. for anything other than a 10BaseT LAN connection or higher,
direct replication (i.e., through the Access menu) is probably fine.
It's not at *all* safe over any lower bandwidth or over a wireless
connection.

2. don't copy replicas around via the file system. Use them in place
on the laptops and synchronize when they are back in the office.
Once they are on the LAN, they can then use the shared replica on
the server. You say "or they send the copy of the MDB." That is
WRONG and will eventually lead to corruption of your replica set and
data loss.

Spend some time on http://www.trigeminal.com reading the replication
articles (which explain all of this) and then spend some time
reading the archives of microsoft.public.access.replication. You'll
see that 40% or more of the articles on that newsgroup are by
Michael Kaplan. Once you've read Michael's articles, you'll see that
this is A Good Thing.

Post back here with questions, or post them in the replication
newsgroup.

For what it's worth, I used to do lots of replication work, but now
prefer solving the same set of problems with Windows Terminal
Server, instead. Replication was simply too fragile for implementing
reliable data exchange in the kinds of environments my clients were
working in.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Daniel | last post by:
Ok..here is my problem. I have two SQL servers that I need to have identical, at least semi-real time data on. One is in a public DMZ with full access to and from the internet, and one is behind...
0
by: Philip Trim | last post by:
General Brief: 3 SQL Servers as MS SQL Server 2000 Standard Edition with Service Pack 3 All using FTP for snapshots All Servers are both Publishers and Distributors. Server A has the correct...
1
by: Uli | last post by:
Hello group, i am relatively new to SQL-Server database, but i have lots of experience with DB2 and Oracle Database. One of my tasks is setting up a replication between a Mysql-Database running...
4
by: someguy | last post by:
Hi, We are going to be running two SQL Server 2000's from the same physical server, with Windows Server 2003, and I need to have certain tables between them syncronized. Database A is a backend...
3
by: SimonDB | last post by:
The replication of my database was successful and it works well. I can modify tables and forms, except for one thing : VBA ! I canít add code in VBA, the error message : "incorrect data format". I...
4
by: Jeff Smith | last post by:
Hi Is there a way to do partial replication of data? I'm looking at having a central back end data file which contains all the data from all users. But when each user synchronises the mobile...
13
by: Naeem | last post by:
What are the ways data can be transported/moved among these Products. SQL Server, Access and Excel. The main ways are: Replication Service, BackUp and Restore, Data Link Server,Import/Export...
1
by: rolandsun | last post by:
we are designing a data collecting system, at each site we have a database and have a central database,we will write data to site's database, we want the site-database can publish the data to...
3
by: Veeru71 | last post by:
We have got 2 DB2-UDB databases (DB1 & DB2) running on separate instances( Inst1 & Inst2). DB1 has got Schema1 and DB2 has got Schema2. We would like to setup some kind of replication to...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.