If you have a new account but are having problems posting or verifying your account, please email us on for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact

Connecting two offices

  • 23-07-2009 9:16pm
    Closed Accounts Posts: 602 ✭✭✭

    There are two offices in different towns about 10 miles apart. Both have DSL.

    Office 1 has a windows workgroup with 5 users, soon to be 7. Office 2 also has a workgroup but with 3 users, soon to be 4.

    Both use an application that uses MS Access (indexing/linking to word docs) and Cobol files, for it's data. They would rather they had a single data location.

    Office 1 is about to change from Workgroup to Client/Server, whether or not the two offices end up connected. The server will be a Dell T410 costing about €3000 inc. OS, CALs and Exchange.

    The connecting of the offices is not vital and very much depends on cost, which has ruled out Terminal Server. Would VPN work, mapping to the data folder in Office 1?


  • Registered Users Posts: 8,813 ✭✭✭BaconZombie

    Have a look into OpenVPN on pfSense.

    What speed are the DSL lines and what would the business impact me if one site lost all access to files shares and other hosted system?

  • Closed Accounts Posts: 584 ✭✭✭aidankk

    i would say that VPN would never be good enough over dsl to an ACCESS Database, it will be to slow and will take too long to update.

    Terminal Services is the only way to go, (well other similar options) , it would not be that expensive, you just get Terminal Services licenses for the remote users instead of local client licenses. You will need to add a half decent pc or a cheap server with 2003 or 2008 installed and add terminal server client access licenses.. You could get a HP ML115 with 2-4 gigs of ram and 2003 oem for a very reasonable price.. (any similiar low end server will do the same, just ,make sure and have enought RAM.)

    I have no doubt that any other option might be a huge dissapointment, judging from expierance..

    The main issue will be accessing shared files on a remote network through a slow vpn will not be practical, access and word or excel are just not designed to work this way.

  • Registered Users Posts: 55 ✭✭johnmd

    Trynig to use access via a WAN will result in you corrupting the access db,as it uses MDAC which is horrible over a VPN connection.
    TS+ Vpn is the better way to go.
    Or if only one user at a time was required you could simply turn on remote desktop on the destination site machine and NAT the rdp port directly to the machine,only allowing access from the WAN IP of the other office.