Interesting remote update scenario - PLEASE HELP 
Author Message
 Interesting remote update scenario - PLEASE HELP

Hi

Here is the scenario:

* Our client has a file-server with an Access DB
* We have a Win NT web-server with the same Access DB

* Our client's DB is constantly being updated with the latest stock
etc. from their factory.
* Our DB gets updated by our client's reps. They are updating our DB
because we have a web-server and they can dial into it to update the
DB with their sales etc. They cannot dial their own file-server.

The client's server also dials into our web-server. This is done 3
times a day.

The question:

* Is there a way to update our DB with the client's DB AND visa versa
so that both are the same at the end of this process? This should be
done when the client's server dials our server.

To see a diagram of the situation you can browse to:

http://www.***.com/


Thanks in advance
MetaMan



Sun, 18 Jul 2004 17:12:44 GMT
 Interesting remote update scenario - PLEASE HELP

What you are attempting is called "replication", and there are many problems
to consider. You may find some info on the topic by using a search engine.
Also, Lotus Notes handles replication fairly well, so you may find some info
at lotus.


Quote:
> Hi

> Here is the scenario:

> * Our client has a file-server with an Access DB
> * We have a Win NT web-server with the same Access DB

> * Our client's DB is constantly being updated with the latest stock
> etc. from their factory.
> * Our DB gets updated by our client's reps. They are updating our DB
> because we have a web-server and they can dial into it to update the
> DB with their sales etc. They cannot dial their own file-server.

> The client's server also dials into our web-server. This is done 3
> times a day.

> The question:

> * Is there a way to update our DB with the client's DB AND visa versa
> so that both are the same at the end of this process? This should be
> done when the client's server dials our server.

> To see a diagram of the situation you can browse to:

> http://www.metasoft.co.za/misc/update.gif


> Thanks in advance
> MetaMan



Sun, 18 Jul 2004 23:26:32 GMT
 Interesting remote update scenario - PLEASE HELP
Thanks a million Alan. I will do some "replication" research!
Quote:

> What you are attempting is called "replication", and there are many problems
> to consider. You may find some info on the topic by using a search engine.
> Also, Lotus Notes handles replication fairly well, so you may find some info
> at lotus.



> > Hi

> > Here is the scenario:

> > * Our client has a file-server with an Access DB
> > * We have a Win NT web-server with the same Access DB

> > * Our client's DB is constantly being updated with the latest stock
> > etc. from their factory.
> > * Our DB gets updated by our client's reps. They are updating our DB
> > because we have a web-server and they can dial into it to update the
> > DB with their sales etc. They cannot dial their own file-server.

> > The client's server also dials into our web-server. This is done 3
> > times a day.

> > The question:

> > * Is there a way to update our DB with the client's DB AND visa versa
> > so that both are the same at the end of this process? This should be
> > done when the client's server dials our server.

> > To see a diagram of the situation you can browse to:

> > http://www.metasoft.co.za/misc/update.gif


> > Thanks in advance
> > MetaMan



Mon, 19 Jul 2004 14:12:18 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Please help: Updating a remote Access Database

2. Interesting Scenario

3. Interesting Scenario

4. Interesting Scenario

5. Interesting Scenario

6. Interesting Replication Scenario

7. Guru Advice Needed for Query on Interesting Data Scenario

8. Interesting Scenario

9. Interesting Scenario

10. Interesting Scenario

11. Interesting Scenario

12. Interesting Scenario


 
Powered by phpBB® Forum Software