Creating a remote database and merging with master

[Guest]

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?

 

[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

 

[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

 

[David W. Fenton]

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

Your choices 1, 2 and 3 and I'd put in the order 1, 3 and 2. But
then, I'm very experienced with replication.