473,320 Members | 1,839 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Syncronize two copies of a database

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
2 1325
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
-----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-----
WØCBF 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: paolo.riba | last post by:
Hi everybody! Could anyone know how can I syncronize a horizontal scrollbar with a listview? Actually I can only syncronize the horizontal scrollbar with the listview horizontal scrollbar, but...
1
by: jsnX | last post by:
hi, i would like to make some code that operates on sets of points - does convex hulls and other operations. but it looks like i will need a lot of pointless object copies: ...
9
by: David Allison | last post by:
cmdButton to Print 3 copies of record in Form view ? cmdButton will print 1 but I need 3 copies of the one Form record. -- Dave Allison
3
by: TDIOwa | last post by:
I have a report printing form (Access 97) in which I print different reports from. I have added a combo box that selects the number of copies that I want to print. Here is the rub... The...
0
by: Jim Irvine | last post by:
I have a couple of users that are using exact copies (Structurally) of a split database. The database has 14 tables with numerous 1 to many realationships. I need to find a way to merge the data...
3
by: Tim | last post by:
Is it possible to select the number of copies of a report from a variable input in a form ? -- Tim Patton ICT Controller Springfarm Architectural Mouldings Ltd Antrim, N.Ireland
2
by: jritacco | last post by:
I have a user that is somehow managing to open multiple copies of a single Access database. We are using Access 2003 and everything I have tried makes it IMPOSSIBLE to open the same database more...
12
by: eyalco | last post by:
I have a report which I need to copy in 2 different lables. I've set a table with numbers from 0-10 (0 gets "original and all the others get "copy"). The caption is changed by IIF - so now all is ok....
1
by: ccmanc68 | last post by:
I would like to print two reports a once. The first report is a sign sheet; the second is an order form. The sign sheet contains the same information as the order form but has a different layout. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.