I currently wrote an app that is located on the individual PC's. I want to update the Access DB that is stored locally from a Main Database that is on a Networked shared server.
The databse has 10 tables in it. I have created a field for the local database that is table.LastUpdate
The server database has a field for every row that is table.partupdated.
So when I run the query instead on updating 400 MB's of data that it only updates >= table.LastUpdate
I am having problems with the way to create the transfer of the data. i dont think I can just pass the dataset returned from server to local. i believe I have to use some sort of streamreader or datarow.
The second part is if a row doesnt exist in local.db I would have to use an insert into not update command correct?
Or is there a way to accomplish both at the same time?
Any suggestion to point me in the right direction would be great.
Thanks for the Help.
MJ - Little Experience but I love to learn.