albertkhor
Well-known member
- Joined
- Jan 12, 2006
- Messages
- 150
- Programming Experience
- Beginner
i develop a system will can sync database between PC and PDA.
my database (ms access) is using primary key, after testing few days i found out a problem but i do not know how to solve it. Hope some one will help me~
my system allow user to backup and restore the database.
Because of this my system having a problem. Let make a example, my PDA database have 20 records and my PC database no have any record. So after i sync now both PDA and PC also have 20 records. After that i restore my PDA database now my PDA database only have 18 records. Then i insert 4 data (my PDA database have 22 record). Now the problem appear, after i sync, PC only insert another 2 data to it database because the record for 19 and 20 is already available in database (which mean PC only copy record 21 and 22 from PDA).
So how to fix this logic problem? Some one please help me~
my database (ms access) is using primary key, after testing few days i found out a problem but i do not know how to solve it. Hope some one will help me~
my system allow user to backup and restore the database.
Because of this my system having a problem. Let make a example, my PDA database have 20 records and my PC database no have any record. So after i sync now both PDA and PC also have 20 records. After that i restore my PDA database now my PDA database only have 18 records. Then i insert 4 data (my PDA database have 22 record). Now the problem appear, after i sync, PC only insert another 2 data to it database because the record for 19 and 20 is already available in database (which mean PC only copy record 21 and 22 from PDA).
So how to fix this logic problem? Some one please help me~
