Synchronise data

[Guest]

Good morning,

I am considering setting up a company directory Access database to be used
by multiple users in various offices of our company. We currently have
several offices w/ local LANs setup and we've got some WAN connectivitiy in
sense of our Email server, and Internet connectivity, but there is currently
no server setup for file sharing between our offices, and very little setup
for file sharing between comptures even in same office location. So the vast
majority of our users work on stand alone machines, connected to our LAN via
Internet and Email.
Because of this, I would probably create this database to be installed
directly on each computer's c: drive and then find someway to have this
program automatically (or manually prompted by user) to import or synchronise
data w/ a master list once a day or every few days. Is this easily done in
access? and how would I do this? Thanks.

Cordially,

 

[Larry Linson]

There is a feature of Access called "replication". I would not call it
simple; in fact, I would say it is "not for the faint of heart". It is also
too extensive for a newsgroup "tutorial". One of the most knowledgeable
people in this area is Michael Kaplan, who has a website
http://www.trigeminal.com, but who doesn't respond to e-mail requests for
assistance. Another person with good knowledge and experince is David
Fenton, who frequently posts in comp.databases.ms-access (which newsgroup is
archived, as are most of the microsoft.public... newsgroups, at
http://groups.google.com).

A company directory, or address book, application may be simple enough that
you could use an Access application to maintain the database, but let the
other locations access it via an intranet, or via the Internet. You could
most likely handle the web access application part with Microsoft Front Page
and the Data Interaction Wizard.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP

 

[Guest]

Good afternoon Larry,

Excellent. Thanks for the good info. I'll look into those. I appreciate your
assistance.