I have an (ACCESS 2000) application that I can work on both at home and at work. I can change the database in either location and I can carry the changed database tables to the either place I am going to one at.
That means that I have to reconcile the data by replacing the old data with the new data. What is the best way to go about this?
Do I replace the entire data?
Do I replace only changed rows? If so, how? Do I have to be prompted before replacing a row?
Does anybody have sample code he/she can spare me.
if i am interpreting what you are saying correctly, you could replicate your database (create replica function) and then just use the "synchronize" feature to synchronize the data in the two databases.