Remote Sync -- SQL 2000

I am just beginning development of a new app and I need a little advice on
the best way to go about doing something.

The app is a project management tool for a construction company. Users in
the field will need to do remote updates both receiving and submitting data
back to the main office. I can't just make it a live web app because the
users will have to be able to work off line and sync data later (presumably
with a VPN connection).

What is the best way to go about this? I planned on using MSDE 2000 w/Access
front end. I will install MSDE on each laptop but what is the safest/most
reliable way to sync only that information which pertains to a specific user
along with other general information.

Any books that helpful with this specific issue? Any one have reusable
modules/code they'd be willing to send me?

TIA,

--JakeCXonsider replication, transactional or merge. Transactional is the
easier of the tow options but does mean that oly one side can make
changes to the data. With merge both sides cna change the data and you
create a set of rules to decide whic update is accepted.

Jake Jessup wrote:

> I am just beginning development of a new app and I need a little advice on
> the best way to go about doing something.
> The app is a project management tool for a construction company. Users in
> the field will need to do remote updates both receiving and submitting data
> back to the main office. I can't just make it a live web app because the
> users will have to be able to work off line and sync data later (presumably
> with a VPN connection).
> What is the best way to go about this? I planned on using MSDE 2000 w/Access
> front end. I will install MSDE on each laptop but what is the safest/most
> reliable way to sync only that information which pertains to a specific user
> along with other general information.
> Any books that helpful with this specific issue? Any one have reusable
> modules/code they'd be willing to send me?
> TIA,
> --Jake
>