I have a short database in order to wrap another system which have the information I need. This Wrapper is done in Access and i have to chek the server for new information every night. The question is, since my Wrapper have 9 tables and the amount of register is around 4000, Do i have to look only for field modified or can I just make a copy from all the dates I need?(I mean, tobuild the hole Wrapper again) I know there are so much information but, is it worth to look for modifications in all the dates ?
It depends on how accurate you need your wrapper data to be... If "close" is good enough, you can probably make the checks simple. If accuracy is important, you should probably just recopy the whole thing, just to be sure.