?
Solved

Synchronizing SQL Server CE with Microsoft Access

Posted on 2004-04-14
10
Medium Priority
?
950 Views
Last Modified: 2013-12-27
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
Comment
Question by:cgedemer
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 48

Accepted Solution

by:
Mikal613 earned 252 total points
ID: 10824867
0
 
LVL 7

Assisted Solution

by:CJCraft
CJCraft earned 244 total points
ID: 11228128
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
 
LVL 3

Assisted Solution

by:Fordraiders
Fordraiders earned 244 total points
ID: 11246198
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
LVL 3

Expert Comment

by:Fordraiders
ID: 11250709
0
 
LVL 1

Expert Comment

by:skyknight
ID: 11453764
nO you CaN't, You mUst use SQL SERVER and then you convert it into your mdb.
0
 
LVL 1

Expert Comment

by:skyknight
ID: 11453780
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
 
LVL 48

Expert Comment

by:Mikal613
ID: 12181073
Split
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Progress means simplifying, not complicating. Bruno Munari Preface How to detect the name of the internal storage or an SD-card on Windows Mobile device from the desktop application? I got this question, when I was working on a PC applicati…
You should read OS supplied guidelines before developing. I can't stress that enough. The guidelines will help you understand the reasons mobile app developers do what they do.  Apple is very particular when they review appstore submissions.
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question