Creating a remote database and merging with master

Channell · External Since: Aug 09, 2007 Posts: 2

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] · External Since: Feb 26, 2004 Posts: 2750

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Channell" <Channell.DeleteThis@discussions.microsoft.com> wrote in message
news:DE3CC470-7DE1-498C-8565-7A2EEE3CC20C@microsoft.com...
>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?

Kelvin Beaton · External Since: Jul 25, 2007 Posts: 5

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

"Channell" <Channell.RemoveThis@discussions.microsoft.com> wrote in message
news:DE3CC470-7DE1-498C-8565-7A2EEE3CC20C@microsoft.com...
>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?

David W. Fenton · External Since: Dec 25, 2005 Posts: 940

"Arvin Meyer [MVP]" <a.RemoveThis@m.com> wrote in
news:O#CHNXp2HHA.5980@TK2MSFTNGP04.phx.gbl:

> 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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/