sync a database

[Ivor Williams]

I have a split database with the tables on a server shared by a number of
users in the office. Some of these users use laptops away from the office.
Is it possible to set things up so laptop users can use the database and
sync up with the tables on the server when they log back on to the office
network? When on the road, they don't always have internet access when it
would be most useful to enter or view information.

 

[John Vinson]

I have a split database with the tables on a server shared by a number of
users in the office. Some of these users use laptops away from the office.
Is it possible to set things up so laptop users can use the database and
sync up with the tables on the server when they log back on to the office
network? When on the road, they don't always have internet access when it
would be most useful to enter or view information.

The solution to this problem is called "Replication". It's a fairly
complex technique and needs to be done correctly; get the Replication
Whitepaper from Microsoft's website and study it carefully:
http://support.microsoft.com/kb/282977/en-us

John W. Vinson[MVP]