Data Transfer

[AndyShuter]

Ok chaps, here's one for yer!

I have one data base, shared between 2 computers. One is 50 mile away from the other so the only way of communication is the net. Both structures are identical.

What i would like to do is be able to set up a link that automatically updates the other machine when a change or addition has been made to the Data.

It would also be great if I could create an alert, so that each machine knew when such a change had been made so they can immediately act on it

Many Thanks - (in advance!)

 

[crosmill]

I think real time updates accross the net with access is a bit abitious.

Access will replicate databases which can be synchronised. I think there's quite a hefty data transfer 'on sync' so unless you can chuck oodles of cpu/memory/bandwidth at it, irregular syncs are the way forward.
If you want to monitor the changes then you could create a query that so you could review any amends to data after the sync.

I'm just about to look into the same problem, to see how secure/viable it is to do this, maybe we should trade notes?

Chris