Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 962
  • Last Modified:

Synchronizing SQL Server CE with Microsoft Access

I have a desktop application which stores its data in an mdb and PocketPC application which stores its data in SQL Server CE.  The database structures are the same.  Can anyone tell me how I can synchronize these two databases?  Can it be done?  A good source of reference would be greatly appreciated.  Thanks.
0
cgedemer
Asked:
cgedemer
  • 2
  • 2
  • 2
  • +1
3 Solutions
 
Mikal613Commented:
0
 
CJCraftCommented:
I'd use SQL CE RDA Replication on the handheld to synchronize with a desktop SQL or MSDE database and then synchronize with a linked server to Access from the desktop database if possible. Not certain it can be done.

You could write a Web service and send datasets from the handheld to the desktop and then export and import as needed, this would be easy since databases are the same.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
FordraidersCommented:
0
 
skyknightCommented:
nO you CaN't, You mUst use SQL SERVER and then you convert it into your mdb.
0
 
skyknightCommented:
nO you CaN't, You mUst use SQL SERVER and then you convert it into your mdb.

see this page as reference

http://msdn.microsoft.com/library/en-us/dnroad/html/road05222002.asp?frame=true
0
 
Mikal613Commented:
Split
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now