From out there on the moon, international politics look so petty. You want to grab a politician by the scruff of the neck and drag him a quarter of a million miles out and say, "Look at that!"
I have pulled down records from the server to my local Access db. However, i dont want to delete the records from the server database.
What i need to do is to check if a record on the server already exists in my local db. if it doesnt, i would like to download it. If it exists, i would like to EDIT the record in my local db to accept the new changes from the server. Unfortunately, since i am not very familiar with working with Text files, i dont seem to get the logic required to accomplish this task.
Please advice me how i could do this.
MICAH
Reply from Richard Rost:
Well, you could simply make a Yes/No field on your SERVER database indicating when this record is changed. Set it to YES whenever the user submits a change, then you only have to download those. You could even make that a separate run (one batch for NEW records, another download for EDITED records) and then in that run look up the local record and just make changes instead of adding it new. Does that help?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
