I am making a VB application that uses an Access DB to store information about books (authors, titles, descriptions, etc...). However, a main Access DB is located on a web server. Every now and then I want to be able to synchronize the two databases so that the records are the same. New book records will be added on the web server DB and the client side DB at the same time. Therefore, I can not simply just replace the existing DB file with a new one.
Any ideas of how I can sync these two DBs?
Any ideas of how I can sync these two DBs?