Creating a remote database and merging with master

C

Channell

I have created a database that I would like to create a remote for, so that
someone else can help me to enter the data. How would I go about doing that
and then merging the databases together again?
 
A

Arvin Meyer [MVP]

You have basically 3 choices. The 1 I prefer is terminal services which
allows the remote user to log into your machine or better yet a server and
directly update data. I like this because there's rarely and conflict
resolution problems. I use RDP built in, Windows Terminal Server, if I have
a lot of users, or lately, WinConnect:

http://www.thinsoftinc.com/product_thin_client_winconnect_server_xp.aspx

The next choice is using aan asp or similar web service to connect to the
data. I dislike that one because it is expensive to write and maintain by
comparison to other choices.

Lastly, there is Access replication which allows you to sunc up data from
multiple separate sources.

http://support.microsoft.com/default.aspx?scid=kb;en-us;182886
 
K

Kelvin Beaton

Are you and the other user on the same network?

If so, split the database, but the backend on your network where both of you
can access it, and put a copy of the front end on each of your computers...

Kelvin
 
Top