Improve company productivity with a Business Account.Sign Up

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

Offline Access Database Synchronization vs Offline SQL Server Database Synchronization?

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
CoopIS
Asked:
CoopIS
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
"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
 
CoopISAuthor Commented:
Any other comments?
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
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 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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