Solved

Files and Folder Replication, Windows 2008

Posted on 2013-01-09
4
372 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

867 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now