automatically synchronising replica
Posted on 2013-01-15
i've got a replica access database. the design master is in the network drive and the replicas are on the local computers of my colleagues.
is there a way that i can trigger the synchronising? i've split the database into FE and BE so i'm only synchronising the BE.
1) me trigging the synchronising would be the best in my opinion ATM, 2) failing which can i schedule it, 3) failing which how can i set up an event that triggers this synchronisation?
i'm thinking when the staff closes the FE then it will look for the BE in the same folder and then start the synchronisation.
if possible can yall include some code? thanks guys!!!
feel free to suggest the best way i can do it. the network here is way way way too slow. replication was the only way i could make things work. it took 5 minutes to open a 30MB database. thanks guys!!