Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Files and Folder Replication, Windows 2008

Posted on 2013-01-09
4
Medium Priority
?
380 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 2000 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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

610 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