Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Offline Access Database Synchronization vs Offline SQL Server Database Synchronization?

Posted on 2011-03-07
3
Medium Priority
?
258 Views
Last Modified: 2012-08-13
Currently, we are using replicas of an Access database so that a number of people can use the database while disconnected from our network. When they come back into the office, they synchronize their copy of the database (with any modifications made) to the master and they also download changes made to the master directly to their replicas or from synchronization from other disconnected users.

We want to look into using a SQL server instead of an Access server. Is it possible to use synchronization with SQL even if the users are disconnected from the network?
0
Comment
Question by:CoopIS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35061097
"Is it possible to use synchronization with SQL even if the users are disconnected from the network?"
"synchronization" or "replication"?

See here:
http://msdn.microsoft.com/en-us/library/ms151198.aspx

Or Google for more...
0
 

Author Comment

by:CoopIS
ID: 35072337
Any other comments?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 35072674
You can wait a few days to see if another Expert chimes in.


Replication is becoming a thing of the past in some circles.

With the advent of technologies like:
Terminal Server (Services)
Ctrix
VPN
Access Web Databases (Access 2010)
Remote log in apps
Remote Access
Remote Assistance
Access email Data collection
MS SharePoint
... the world is becoming "Always connected"
So having users "disconnected" from the data is becoming more and more a thing of the past.

As you know, because of conflicts, replication was never "Perfect" and sometimes needed some baby-sitting.
One theory is that the reason MS Dropped support for replication in 2007 is because of these new technologies

So you may want to look into one of these alternatives...

;-)

JeffCoachman
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

610 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