[Webdev] Syncronising distributed dbs

[John McCormac]

Barry Redmond wrote:
> 
> Before I start reinventing wheels maybe someone can tell me how
> much of this particular wheel already exists.
> 
> I want to set up a server of some kind (on Linux) so that individuals
> running MS Access at home can syncronise their copy of a simple
> database with a copy held on the server.  The users have dial-up

Using a number of different database types can make it difficult. The
simplest method is to use a centrally updated database file. This can be
an Access .mdb file if all the others are using Access. The difference
between the Access db on the users' computers and this one is that all
the columns will be prefixed 'Temp'. The users can then run a macro in
Access to import the changes by comparing the Temp data with their
existing data. The users can also run another macro to export the
changes they have made (this time using the prefix Username) but that
can make the model slightly more complex. This kind of model is actually
more common than people realise ;-) since it underpins Usenet.  

Regards...jmcc
-- 
********************************************
John McCormac            * Hack Watch News
jmcc at hackwatch.com       * 22 Viewmount, 
Voice:   +353-51-873640  * Waterford,
BBS&Fax: +353-51-850143  * Ireland
http://www.hackwatch.com/~kooltek
********************************************

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6

mQCNAzAYPNsAAAEEAPGTHaNyitUTNAwF8BU6mF5PcbLQXdeuHf3xT6UOL+/Od+z+
ZOCAx8Ka9LJBjuQYw8hlqvTV5kceLlrP2HPqmk7YPOw1fQWlpTJof+ZMCxEVd1Qz
TRet2vS/kiRQRYvKOaxoJhqIzUr1g3ovBnIdpKeo4KKULz9XKuxCgZsuLKkVAAUX
tCJKb2huIE1jQ29ybWFjIDxqbWNjQGhhY2t3YXRjaC5jb20+tBJqbWNjQGhhY2t3
YXRjaC5jb20=
=sTfy
-----END PGP PUBLIC KEY BLOCK-----