Solved

Offline Access Database Synchronization vs Offline SQL Server Database Synchronization?

Posted on 2011-03-07
3
249 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
  • 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 250 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

856 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