A
Angus Comber
Hello
I want to synchronise between two databases. Specifically between a list of
tasks on a mobile phone and a table of Tasks in an Access database. The
fields are slightly different in the two database types and the common
fields are task (text) and Priority (low, medium or high).
I was thinking of doing it this way (but I wondered if there was a
quicker/more efficient method.
1. Get mobile phone task.
2. Do a SELECT * FROM Tasks WHERE Task = 'MobilePhoneTask'
3. If no match just copy over from mobile to Access db.
3a. If a match go on to next mobile phone task.
4. Lookup next mobile phone task and carry on.
When done doing this go, do same thing but from Access db side.
This is reasonably straightforward. But there is a bit of duplicated effort
there. for example all tasks copied from mobile to Access do not need to be
checked.
Perhaps to cut down sync time is an Edit Date/Timestamp a good idea?
Any feedback help on this subject would be most appreciated.
Angus Comber
(e-mail address removed)
I want to synchronise between two databases. Specifically between a list of
tasks on a mobile phone and a table of Tasks in an Access database. The
fields are slightly different in the two database types and the common
fields are task (text) and Priority (low, medium or high).
I was thinking of doing it this way (but I wondered if there was a
quicker/more efficient method.
1. Get mobile phone task.
2. Do a SELECT * FROM Tasks WHERE Task = 'MobilePhoneTask'
3. If no match just copy over from mobile to Access db.
3a. If a match go on to next mobile phone task.
4. Lookup next mobile phone task and carry on.
When done doing this go, do same thing but from Access db side.
This is reasonably straightforward. But there is a bit of duplicated effort
there. for example all tasks copied from mobile to Access do not need to be
checked.
Perhaps to cut down sync time is an Edit Date/Timestamp a good idea?
Any feedback help on this subject would be most appreciated.
Angus Comber
(e-mail address removed)