Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer

Brief Description
Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device.

On This Page

Quick Details
Version:-
Date Published:2/19/2007
Language:English
Download Size:182 KB - 1.2 MB*
*Download size depends on selected download components.

Overview

Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device.

The setup installs the desktop component required for synchronizing Microsoft Access database with SQL Server Compact Edition database on the device. It also includes a read me file which has the documentation for the solution and a sample application. The sample application shows how the solution works and how to write applications for this solution. The components installed on the desktop can be used by third party applications to provide data synchronization between Microsoft Access database on the desktop and SQL Server Compact Edition/SQL Mobile database on the device.

 Top of page

System Requirements

  • Supported Operating Systems: Windows Vista; Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition ; Windows XP Service Pack 2; Windows XP Tablet PC Edition
The following versions of Microsoft Access will be supported:
• Microsoft Access 2000 SP3 (Microsoft Office 2000) • Microsoft Access 2002 SP3 (Microsoft Office 2002) • Microsoft Office Access 2003 SP2 (Microsoft Office 2003) • Microsoft Office Access 2007

 Top of page

Instructions

You should have the following software installed on your computer before using ADS to synchronize your data:
• Microsoft Access 2000 or a later version
• Microsoft ActiveSync 4.0 or a later version

Once the desktop is setup for synchronizing, you have to make sure that there is an ActiveSync connection setup between the desktop and device. Synchronization will not be possible if there is no ActiveSync connection established. To install the sample application on the device, copy the sqlce.access.sample.PPC.wce5.armv4i.CAB file that is located at \Program Files\Microsoft SQL Server Compact Edition\v3.1\Sync\Access to the deivce and execute it. To run the sample application on a Windows Mobile 5.0 Pocket PC, NET CF 2.0 and SQL Mobile/SQL Sever Compact Edition need to be installed on the device.

 Top of page

Files in This Download

The links in this section correspond to separate files available in this download. Download the files most appropriate for you.
File Name:File Size

AccessDatabaseSynchronizer-EN.msi

1.1 MB

Readme.doc

182 KB

 Top of page

 Top of page

 Top of page


© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement