Syncronizing Laptop copy and Main Copy

[TwinDad]

I have two databases that I am currently testing. I have created a Replica
copy but would like to have the replicate as soon as the can connect to the
network. we connect two ways.

1. Direct
2. VPN

With the VPN they are not directly mapped to the drive. I can get it to
work with the \\{network name\ etc. but I would like for it to loop until it
finds it or have a button that syncs with it.

Does anyone have a simple method to do both?

I am planning on giving this to 200+ sales people, and 3 driver supervisors.

They will be out in the field working on this and possibly connect (possibly
by VPN), then sync with the information.

Will I have a problem with the amount of people using the database?

Thanks in Advance,

-The Novice

 

[Iggies]

My experience with stand alone access databases is that the do not work that
well when shared, particularly with the number of people you are sharing
with.
The best solution is to convert your database to a SQL backend. The SQL
tables reside on the server and when each user logs in it updates the one
master copy of SQL tables. There is quite a bit of info in the help files on
how to convert your database, and there is a utility to create the tables.
You will need to have a SQL server though and access to it.