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

Syncronize two copies of a database

P: n/a
I have an Access application that I wrote for a very specific business.
They now want to put a copy on a laptop and retain the application on
their PC. Then they want to modify data on both the laptop and PC then
merge the data together making the two copies of the same, for example
at the end of the business day. 99.9% of the time the same records
would not be changed. Is this possible in Access ???

Thanks
Chuck

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes but it probably won't be easy to change your existing database to
work. You will want to add GUIDs and other things. Access has a whole
replication wizard and sync wizard. Take a look through the help and
you may find everything you need.
HTH
Pachydermitis

Nov 13 '05 #2

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes it is. It is called Replication. You'll have to change the
original database (the data portion [tables] only) to be the Master db.
Read the Access Help articles on Replication to find out how to do it.
The Help Contents hierarchy on Replication:

Database Replication
Understanding Replication
Replicating a Database
... etc. ...
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
.. -..- / ..- ... -.-. --. / .-. .- -.. -- / -. -- --.

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlrTYYechKqOuFEgEQL4lACgu3NcVsxvhrBfCzZ7JS4sQJ RHseEAoIjb
Je4BgvCqj+Rm51ayXi5NSIBI
=HhM4
-----END PGP SIGNATURE-----
WCBF wrote:
I have an Access application that I wrote for a very specific business.
They now want to put a copy on a laptop and retain the application on
their PC. Then they want to modify data on both the laptop and PC then
merge the data together making the two copies of the same, for example
at the end of the business day. 99.9% of the time the same records
would not be changed. Is this possible in Access ???

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.