One of the many features that was lost when Windows Mobile 5 came out was the ability to sync Microsoft Access databases with a Pocket PC. A few weeks ago Microsoft provided a workaround that can synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device. You can find it linked below…
Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer
how to sync mobile with sql server 2005
sqlserverce is a great site actually
You can find more information on SQL Server CE at the community portal at http://www.sqlserverce.org.