By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,172 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,172 IT Pros & Developers. It's quick & easy.

Synchronizing Microsoft Access

P: n/a
I have an Access database that I use frequently. Often, I take it to
a home PC, or laptop to work on at night. The next day, I overwrite
the old one with the one I have been working on.

The only problem is - during this time, others may want to add records
at the office. This causes an obvious data loss problem if I
overwrite their edition of the database.

Is there a way to synchronize the database? If someone made additions
at the office, and I made additions (or edits, deletions, etc) at
home, can they both be resolved some how? This would be very helpful.

Phil
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Two choices:

1) Maintain two distinct versions of the database - one for you and
one for "others". Create a third database that links to tables in both
the other databases. Write a series of queries that compare data
between the two versions and makes the appropriate corrections.
Depending on the database complexity, this could be easy or hard.

2) Implement Access' Replication. It's in the Tools menu. This feature
allows you to make changes to two or more replicas of the same
database, and then to synchronize them afterwards. It works well, but
there are several "gotchas" to look out for. For example, it increases
the database size by adding hidden fields and tables, and it requires
that you designate a location for each replica and forever afterwards
refrain from changing that location. In other words, copying from the
LAN to your notebook computer and back again is not allowed. OTOH,
synchronizing between the LAN and your notebook over the wire is fully
supported. Check online Help and read articles at www.trigeminal.com
for advice.
On 9 Jul 2004 04:30:46 -0700, ph****@wesselconsulting.com (Phil
Matish, MCSE) wrote:
I have an Access database that I use frequently. Often, I take it to
a home PC, or laptop to work on at night. The next day, I overwrite
the old one with the one I have been working on.

The only problem is - during this time, others may want to add records
at the office. This causes an obvious data loss problem if I
overwrite their edition of the database.

Is there a way to synchronize the database? If someone made additions
at the office, and I made additions (or edits, deletions, etc) at
home, can they both be resolved some how? This would be very helpful.

Phil

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.