Files and Folder Replication, Windows 2008

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?
LVL 1
DJMohrAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
DJMohrAuthor Commented:
Yes have been looking at SharePoint to run the DB, a lot of work to convert it to web based DB though.
0
 
DJMohrAuthor Commented:
Thanks for your input, would rather not risk messing up the DBs with replication.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.