database compairison help??
-
Hi guys, Here is my situation, I have a program that creates a database, and as long as you do not sync it to the desktop it is fine and works great, you can also export it to the desktop without any negetive side effects, the problem comes when you sync the db back from the desktop to the handheld. Even if you don't edit it on the desktop, the program that I have can't write to some of the tables. It still reads to them but can't edit or add to them. I have not at all changed the tables, just synced to desktop and then brought back to the handheld. Any ideas, I am using active sync ver 3.7 (build 3083). I am wondering if anyone knows where to get something to compare the databases (before sync and after sync). Something is happening during the syncing and conversion process. I am really stuck on this one:(:mad: PLEASE HELP!!! Thanks for the help guys, Rod
-
Hi guys, Here is my situation, I have a program that creates a database, and as long as you do not sync it to the desktop it is fine and works great, you can also export it to the desktop without any negetive side effects, the problem comes when you sync the db back from the desktop to the handheld. Even if you don't edit it on the desktop, the program that I have can't write to some of the tables. It still reads to them but can't edit or add to them. I have not at all changed the tables, just synced to desktop and then brought back to the handheld. Any ideas, I am using active sync ver 3.7 (build 3083). I am wondering if anyone knows where to get something to compare the databases (before sync and after sync). Something is happening during the syncing and conversion process. I am really stuck on this one:(:mad: PLEASE HELP!!! Thanks for the help guys, Rod
If you are using Pocket Access databases (cdb) on the Pocket PC, check if, when they are copied to the desktop, a new key column with an autonumber type is added. Regards, João Paulo Figueira Embedded MVP
-
If you are using Pocket Access databases (cdb) on the Pocket PC, check if, when they are copied to the desktop, a new key column with an autonumber type is added. Regards, João Paulo Figueira Embedded MVP
No there doesn't seem to be a new key column. The only thing that I notice is that some of the indexes disappear. Having the databases missing the indexes doesn't seem to effect the program in any way, as I have created the tables without the indexes and the program still works fine until you bring them across to the desktop and then back to the ppc.Any other ideas???:confused: Thanks every bit helps, I appericiate your suggestions. Thanks, Rod
-
No there doesn't seem to be a new key column. The only thing that I notice is that some of the indexes disappear. Having the databases missing the indexes doesn't seem to effect the program in any way, as I have created the tables without the indexes and the program still works fine until you bring them across to the desktop and then back to the ppc.Any other ideas???:confused: Thanks every bit helps, I appericiate your suggestions. Thanks, Rod
Can you please send me a sample database so that I can test it? Regards, João Paulo Figueira Embedded MVP
-
Can you please send me a sample database so that I can test it? Regards, João Paulo Figueira Embedded MVP
-
Did you get the database that I sent you? I was wondering if there are reserved words such as maybe "Field" or something like that. Any other ideas? Again, Thank you very much, Rod
Hi Rod, Sorry! I've been busy and and got a cold on top of my usual spring allergies... The mdb was blocked. Can you zip it and send it again? Regards, João Paulo Figueira Embedded MVP
-
Hi Rod, Sorry! I've been busy and and got a cold on top of my usual spring allergies... The mdb was blocked. Can you zip it and send it again? Regards, João Paulo Figueira Embedded MVP
-
Yes: I found that you are using an older version of Access. What is it by the way? I cannot replicate you problem because I'm running Access 2003. Regards, João Paulo Figueira Embedded MVP
-
Yes: I found that you are using an older version of Access. What is it by the way? I cannot replicate you problem because I'm running Access 2003. Regards, João Paulo Figueira Embedded MVP
I am using access 2002. should this make a diference since I am having the problem on the hand held side? I am not having a problem openning it on the desktop, The problem comes when the database is synced back into the handheld. Then I can't add to the database on the hand held. Did you install the version I sent you on your handheld? It works fine on there and you can add a visit after syncing back to the handheld from the desktop? Again, Thanks for your help on this, I appriciate it greatly. Thanks, Rod
-
I am using access 2002. should this make a diference since I am having the problem on the hand held side? I am not having a problem openning it on the desktop, The problem comes when the database is synced back into the handheld. Then I can't add to the database on the hand held. Did you install the version I sent you on your handheld? It works fine on there and you can add a visit after syncing back to the handheld from the desktop? Again, Thanks for your help on this, I appriciate it greatly. Thanks, Rod
I figured it out!!!!! Active sync doesn't know how to convert OLE objects so it just discards them. I took these out of the pocket version of the program and it works like a charm. Thanks so much for the help and the time that you put into this João, I really do appriciate it. Till next time, Thanks again, Rod