Solved

Files and Folder Replication, Windows 2008

Posted on 2013-01-09
4
374 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
  • 2
  • 2
4 Comments
 
LVL 84

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 84
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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
extended monitor print screen 8 33
Why does my public IP keep changing? 6 64
Access on Mouse move 5 34
WMI Setup on Server 2012 and 2008 GPO 1 15
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

772 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