Sychronize Data via WEB!! 1

[bitech]

Now this is my important question YET!, that I've posted on Tek-Tips, and if someone could help me out on this one, I'd be completely grateful. Now here's the lowdown.

I have (1)one database, that needs to be used in (3)three different cities. So, because the company doesn't have a WAN set up these (3) different cities will not be connected to one another. Which creates the problem of the information being updated in one city, not being revealed to the other city. Now here are options I've come up with.

1.) Weekly or Bi-Weekly, all 3 cities export there information and email it to the HUB, where the HUB synchronizes it all, and sends it back out to the 3 cities and they would detach the information from there email and place it in the folder in which the database expects the tables to be in.

That creates a problem for obvious reasons. #1, too long of a process, #2 there will be a stoppage in work while the data is being re-sync.


Second Option
2.) Was to publish the information to the website and have it sychronize nightly.

My question

Is there anyone that knows and can help me accomplish my second option?

 

[paron]

You might have a look at faq181-1196 which gives a once-over of the state of the art (and, if you're at all interested, do the tutorials.)

Instant expertise! Well, almost.

Ron