The simplest solution is to enable real time access so that there is only one set of data at location A that location B accesses remotely.

Checkout Windows Server 2008 RemoteApp capability. It's just like Remote Desktop Services except it wraps only the application rather than the entire desktop.

http://windowsitpro.com/article/articleid/98358/windows-server-2008s-remoteapp.html

http://www.microsoft.com/windowsserver2008/en/us/presentation-terminal.aspx

http://technet.microsoft.com/en-us/library/cc753844.aspx



RemoteApp is very, very cool and is simpler for less technical end users as compared to regular Remote Desktop Services.