S
Silvio
Hello everyone, I have an Access 2003 database divided in BE and FE. The BE
resides in a server and each user has a copy of the FE installed in their
computer. Now… the users would like to use they laptop in the field and want
to be able to make data entry and lookup data as needed. VPN does not seem to
be a good option because of the slow speed of the internet via wireless
modems. I was contemplating to possibility of install a modified version of
the FE pointing to data stored in the local drive C. Of course that would
create a synchronize issue - upload new data and download new and/or modified
data from the server once back in office and connected to the LAN. I never
had to accomplish such project and I would like to hear from you how to best
approach this project, handle the synchronization problem (keeping in mind
that several tables use AutoNumber as PK). Any idea, help, advice and tip
will be REALLY appreciate.
Thank you,
Silvio
resides in a server and each user has a copy of the FE installed in their
computer. Now… the users would like to use they laptop in the field and want
to be able to make data entry and lookup data as needed. VPN does not seem to
be a good option because of the slow speed of the internet via wireless
modems. I was contemplating to possibility of install a modified version of
the FE pointing to data stored in the local drive C. Of course that would
create a synchronize issue - upload new data and download new and/or modified
data from the server once back in office and connected to the LAN. I never
had to accomplish such project and I would like to hear from you how to best
approach this project, handle the synchronization problem (keeping in mind
that several tables use AutoNumber as PK). Any idea, help, advice and tip
will be REALLY appreciate.
Thank you,
Silvio