MDB table synchronization

[peggypph]

My customer will install two separate MDBs (identical structure) in two sites. Each user will access and update their local MDBs. The customer requires to have 2 MDB synchronization automatically. Does MDB replicate work fine? But it seems that MDB replication requires all the users log out from the MDB before the synchronization process. The customer must require to do synchronization automatically where the users are still using the local MDB. Please advise me. Thanks

 

[Malcy]

Hi
Sounds an interesting one.
Have you considered using one database which the two sites access remotely from identical front ends at both sites?
I presume that since the client is wanting automatic synchronisation that the two sites can effectively network, either directly or via VPN or some such.
If so then it would seem to me as if having the two sites using the same backend from their local front end would make life much simpler.
The "experts" may well come up with a better solution, but it might be worth pondering this one. Thinking about it maybe designing it as a web using data access pages might make it simpler (but I have never done that so it may not be easy!!)
Good luck and best wishes

Malcy