Data Exchange between Ms Access and SQL 2k5

Question

0.00/5 (No votes)

See more:

I developed an application using C# and Ms Access in which users works in it in provinces (branches).

In each branch we got one Application but in all branches we are using same application with same structure.

In HQ we have same application but in Sql 2k5, C# and ASP.NET with same structure as branches. I want HQ and Branches have the same data.

I used different synchronization mechansim but truely none worked.
I am looking for a kind of synchronization method which I should be able to update both sides.

Please share your ideas with me which method I should use.
I am going to develop the synchronization mechansim.

We have dont have speeded (high bandwidth) internet connection in branches.

Posted 9-Jan-11 23:40pm

Abdul Rahman Hamidy

Updated 10-Jan-11 0:43am

Dalek Dave

v3

Add a Solution

Comments

Sandesh M Patil 10-Jan-11 5:48am

Edited for better readability

Espen Harlinn 10-Jan-11 6:42am

We have dont have speeded (high bandwidth) internet connection in branches?? modem? ISDN? GSM? specify bandwidth please. Less bandwidth == more complicated solution

Dalek Dave 10-Jan-11 6:43am

Edited for Grammar.

Abdul Rahman Hamidy 10-Jan-11 7:17am

bandwidth=64kbps for 6 users.

Abdul Rahman Hamidy 10-Jan-11 7:24am

sorry the correct message is we dont have high bandwidth internet its is only 64Kbps for multi users.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Venkatesh Mookkan · Answer 1 · 2011-01-09T23:54:00

Solution 1

Did you tried using SQL Server CE instead of MS Access. It support data syncronization with SQL Server 2005 or greater.

Take Data Offline Using Microsoft Synchronization Services for ADO.NET[^]

Mark it as answer if it is helpful

Posted 9-Jan-11 23:54pm

Venkatesh Mookkan

Updated 10-Jan-11 0:24am

Comments

Abdul Rahman Hamidy 10-Jan-11 6:05am

thanks, well, I can't rollback to use SQL CE, I have already done one with SQL CE but in this envoirnment I can't go for SQL CE.

Venkatesh Mookkan 10-Jan-11 6:06am

Then you adopt the same method which CE uses for Data Syncronization.

Abdul Rahman Hamidy 10-Jan-11 6:22am

thanks, let me make sure CE uses Columns to identify what is newly added?

Venkatesh Mookkan 10-Jan-11 6:24am

Yes. You need to make sure you use LastUpdated datetime in CE as well as SQL Server (main server). You can write the same logic using MS Access too.

Abdul Rahman Hamidy 10-Jan-11 7:21am

I dont think this is the only mechansim, isnt there any other mechansim to implement?