Synchronize Access on the Internet

[T Martin]

Is it possible to sychronize an Access database across over the internet.
Here's what I'm trying to do:

My company has a Road Rep division and an Inside Sales division. We would
like to be able to maintain contact information, appointments, etc through
an Access database (similar to ACT or Goldmine) and be able to sychronize
between the Road Rep dept and Inside sales dept while the reps are on the
road. Is this possible?

Thanks in advance for your help

T Martin

 

[Douglas J. Steele]

Take a look into Replication: it does exactly what you're trying to do.

Assuming you're using Access 2000 or newer, check
http://support.microsoft.com/?id=190766 - white paper
http://support.microsoft.com/?id=282977 - FAQ

Also see
www.trigeminal.com - excellent replication site
http://support.microsoft.com/support/access/content/repl/replication.asp


By the way, make sure your application is split into a front-end (containing
the queries, forms, reports, macros and modules), linked to a back-end
(containing only the tables). All you replicate is the back-end.

 

[T Martin]

Thanks for pointing me in the right directions.

By the way, I already use a front end/back end database over our network,
but it is always a great reminder to everyone.