Synchronising Access databases

[Kate Davis via .NET 247]

I need to write an application for a Windows CE 5.0 Pocket PCdevice. I need to upload a subset of an existing MicrosoftAccess database from a PC to the Pocket PC. Then the PPCprogram write some data to its database, then when the PPC isput back into its USB cradle, changed records are synchronisedback into the Access database on the PC.

I have read that Pocket Access and ADOCE will not be available onCE5 mobile devices (maybe Microsoft will provide some sort ofretro-fitted patch - I don't know when) and Pocket Access is nomore. So I was thinking about using SQLite, but don't knowwhether I will be able to synchronise with the database on thePC. Has anybody tried this? Can you please point me in theright direction?

Thanks

 

[Saverio Tedeschi]

IMHO the best option is SQL CE Server syncing with MSDE. AFAIK it's free (no
connection to SQL Server) and straighforward (via RDA you only need
PUSH/PULL instructions). Of course there are lots of commercial DBs suiting
weel, but no one is free. HTH.

"Kate Davis via .NET 247" <[email protected]> ha scritto nel messaggio
I need to write an application for a Windows CE 5.0 Pocket PC device. I
need to upload a subset of an existing Microsoft Access database from a PC
to the Pocket PC. Then the PPC program write some data to its database,
then when the PPC is put back into its USB cradle, changed records are
synchronised back into the Access database on the PC.

I have read that Pocket Access and ADOCE will not be available on CE5 mobile
devices (maybe Microsoft will provide some sort of retro-fitted patch - I
don't know when) and Pocket Access is no more. So I was thinking about
using SQLite, but don't know whether I will be able to synchronise with the
database on the PC. Has anybody tried this? Can you please point me in the
right direction?

Thanks

 

[Darren Shaffer]

your best bet would be to get rid of Access and use SQL Mobile
on device and SQL Server 2005 on the desktop. there are some
third party tools that allow you to work with Pocket Access from
the Compact Framework (inthehand), but the next gen of mobile
dev tools move away from Access.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com


I need to write an application for a Windows CE 5.0 Pocket PC device. I
need to upload a subset of an existing Microsoft Access database from a PC
to the Pocket PC. Then the PPC program write some data to its database,
then when the PPC is put back into its USB cradle, changed records are
synchronised back into the Access database on the PC.

I have read that Pocket Access and ADOCE will not be available on CE5 mobile
devices (maybe Microsoft will provide some sort of retro-fitted patch - I
don't know when) and Pocket Access is no more. So I was thinking about
using SQLite, but don't know whether I will be able to synchronise with the
database on the PC. Has anybody tried this? Can you please point me in the
right direction?

Thanks

 

[Jim Cooper]

If you are stuck with Access on the PC end, then you can use either SQL
ServerCE or ADO.NET on the device. It's a bit difficult getting at SQL
ServerCE databases if you aren't using some version of SQL Server on the
PC. ADO.NET databases will serialise to XML and they're easy to move
around and parse/build, but don't scale to large amounts of data too well.

Cheers,
Jim Cooper

__________________________________________

Jim Cooper (e-mail address removed)
Tabdee Ltd http://www.tabdee.ltd.uk

TurboSync - Connecting Delphi to your Palm
__________________________________________