Solved

Files and Folder Replication, Windows 2008

Posted on 2013-01-09
4
377 Views
Last Modified: 2013-01-10
Our company has a few MS Access databases that we use for project and client related purposes. The DBs are located at our HQ so locate users have ready access to it, however, our branch office requires to access the same DBs and they currently do so via Remote Desktop.

Can I setup and configure DFS Manager to replicate the DBs to my remove site?
Are there any draw backs on doing this?
0
Comment
Question by:DJMohr
[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
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 38758142
I have limited knowledge of DFS (which I assume is Distributed File Services), but I believe it only "replicates" files when they are not active - therefore, the only time your Access databases would be replicated would be when everyone has closed out of them.

Also, I'm not sure how well DFS replication would work with Access databases. If your goal is to replicate the databases and provide your remote locations with a copy, and then "merge" all of those copies back into one, then I would suspect you'll be less than pleased with the result.

Here's one guy's take on the matter:
http://www.davidebellettini.com/2012/07/microsoft-access-and-dfs/

Note that Access 2000 thru 2003 supports replication. However, if you truly need replicated data I'd suggest you move to SQL Server - or better yet, just do away with the need for replication and move to a web-based application, or a true client-server application.
0
 
LVL 1

Author Comment

by:DJMohr
ID: 38758150
Yes have been looking at SharePoint to run the DB, a lot of work to convert it to web based DB though.
0
 
LVL 1

Author Closing Comment

by:DJMohr
ID: 38758151
Thanks for your input, would rather not risk messing up the DBs with replication.
0
 
LVL 85
ID: 38762373
Note too that a web-based Access database is somewhat limited in terms of UI and interaction. If the database has any sort of complexity (UI-wise) you won't be able to convert to a web db.
0

Featured Post

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…

690 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