Pocket Access conversion

[Juan]

Hello:

I want to transfer a pocket access database from PDA to PC without
using activesync and without any conversion, and then modify this
transferred .CDB in PC using c# language. Its is posible? if it isn't
posible?, how can I modify a PDAs database in PC without converting
and withtout using activesync?

The reason for do that is because I want to optimize the time the
actual systems takes to synchronize, so the best way is to modify the
PDAs database entirely in PC and to transfer it. With .SDF isn't
posible, so I'm triyng to use CDB.
I use GPRS to transfer files.

Thanks a lot.

 

[Pete Vickers [MVP]]

Hi,
you can transfer it without converting it by changing the settings in
activesync, but you wouldn't be able to read it as the format is internal to
Microsoft.

Why not convert it and just use it as an mdb - that should be simpler?

Pete

 

[Juan]

Hi Pete:

The main trouble is that i can't use activeSync, and want to transfer it
over GPRS, so how would I realize the conversion in one way (CDB to MS
Access) and then in the other way (MS Access to CDB)?

Thanks for your interest.

 

[Peter Foot [MVP]]

The problem with this is that the CDB format is undocumented and the only
CDB to/from Access provider is that within ActiveSync. Probably a more
workable solution would be to transmit the data between the device and
desktop in a different format e.g. Text, Xml, some proprietary binary scheme
of your own construction, you can then write your own logic to synchronise
this data with ADOCE on the device side and ADO or ADO.NET on the desktop.
If you timestamp your data when it is modified then you need only transmit
differences rather than the whole database every time.

Peter

 

[Guest]

The main trouble is that i can't use activeSync...

Hi Juan!!!

Well, if you already have a connection using GPRS, then if I could
suggest to use a web service / web page to upload & download data. It is a
bunch of work (a nightmare, actually) but once you have it you can forget
about ActiveSync and its partnerships. Moreover, you're not limited to a GPRS
connection, but also you could use any other RF protocol, like 802.11 b or g,
bluetooth, cellular networks....

Hope it helps!!!

Tarh Ik

PD: This reply has been posted "AS IS"

 

[Juan]

Thanks Peter

Your response is very useful for me, I want to know that. My first system
inlcuded the propiertary format (XML) and some similar to web services, But
still is too much information to send, the XML is too big, and the parse and
insert process too long. But don't worry about it.

Thanks a lot