Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • 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

Featured Post

Get your problem seen by more experts

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

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