Synchronising with Access

Q: Can I synchronise a SQL Server CE database with Access?

A: Yes, there is currently a CTP version available of the Access Database Synchronizer which can be downloaded here. The following are some of the points of interest:

  • It has been designed to sync with Access, not SQL Express - if you want to synchronise to SQL Server you either need to upgrade to a version that supports Merge replication or investigate using the Microsoft Sync Services (currently in CTP).
  • Synchronisation has to be done via an ActiveSync connection - this currently excludes scenarios that involve syncing across a network (eg wireless).
Published Friday, February 09, 2007 12:36 AM by Administrator
Filed under: , , , , ,

Comments

Monday, February 26, 2007 8:28 AM by adamyp

# re: Synchronising with Access

Question:  I have installed the ADS RTW (02/19/2007) and was able to move data from the Access DB to the Device DB by expanding on the instructions i found on the ADS Readme document.  However, i was unable to send data from the Device to the Access DB.

When i attempted to Connect to the Device db node, i never receive the a tree view populated with its tables(+).  Instead, i only observed a green database connection symbol.  The Device ADS Log file had the following entry, "Pulling table list from Device database".  

I followed the instructions on the ADS Readme file both Push/Pull data and have read everything that i can find on the topic, but have found no insight.

Monday, February 26, 2007 1:26 PM by adamyp

# re: Synchronising with Access

Answer:  i needed to disconnect my ethernet cable.  to perform the sync  - now it works.  

Wednesday, March 26, 2008 7:41 AM by wrv369

# re: Synchronising with Access

I have the sync working using the Sample Synchronization Wizard.  My question is how do I automate the syncing so that when the device (through USB) is plugged into the desktop PC, it pushes it data to the Access database on the desktop?  It seems like some intervention is required by the user to start the pushing of data.  I read something that talked about using RDA, but I still didn't understand how I can start the pushing process similar to how I was doing it when I was using Pocket Access with ActiveSync.  Any tips?  Thanks!