I'm new to web databases and wondered how people synchronize their PC and online databases.
I have a master database in Access 2003, with a copy of tables on the web. The main table can be appended from pc-web, and updated only on the web. So I need to append new records pc-web, then update ammended records web-pc, and send it all back to the web.
From a beginners point of view, what is the easiest way to achieve this from within Access? I'm not sure if I should copy the whole db to the pc, update it then copy it back, but this could take too long.
Any suggestions welcome!
Pete