Synchronising database

Topic

New Reply

Office 2003 under W7RC1
Having split our client database into front and back ends, I’ve been working on the forms on my pc. We copied the front ends to the same named directory on the D: drives of PC1 and PC2 – the idea being is that we could then synchronise the changes that I make in PC2 over to PC1. Setting up and using Synctoy replaced My front end with that of PC1 – not what I wanted. Anyway the backup was quickly restored so only a few changes, this morning, have been lost. So the question is, if I can’t synchronise, do I have to delete the forms in the front end on PC1 and then copy the forms from PC2 to PC1? Or, is there a better / more elegant way please?

Reply | Quote

Replies

Can’t you just copy the frontend database from PC2 to PC1? Or have the users created their own objects in the frontend that they want to keep?

Reply | Quote

Yes, indeed I could Hans – thank you for the comment. The ideas was to be able to make changes in the future and automatically synchronise the computers on a weekly or daily basis.

Reply | Quote

Perhaps you can use Tony Toew’s free Auto FE Updater.

Reply | Quote

Thanks Hans, I’ll have a good look at it.

Reply | Quote