Solved Two Networks 1 Database File

February 17, 2013 at 10:00:18
Specs: Windows 7
I was curious what is the best way and how to setup a network that can do the following:

I have two offices in different cities but I need them to be able to access the same database file.

I can easily share a folder in 1 city and have all those computers access it but how can I share the file with the computers at the other city?


See More: Two Networks 1 Database File

Report •


#1
February 17, 2013 at 10:06:56
I suspect the easiest thing would be to setup a VPN between the two locations. If you use the same subnet across both locations, you wouldn't need to route between locations and all users would have access to your db.

It matters not how straight the gate,
How charged with punishments the scroll,
I am the master of my fate;
I am the captain of my soul.

***William Henley***


Report •

#2
February 17, 2013 at 10:20:41
I have no idea how to do that.

My simple solution I was going to use was create a dropbox account on each networks main computer then share that folder on each network.

Could you explain a little more about VPN and same subnet locations? They are both on seperate types of internets also.


Report •

#3
February 18, 2013 at 08:08:26
✔ Best Answer
If you search "VPN" then you'll find more than enough information on what that is, and how to create one between two remote sites.

As for same subnet in both sites that's siimple enough. Assuming you're using a SOHO Router at each end that's capable of being a VPN endpoint, you could do the following:

Site 1, Router 1:
LAN IP: 192.168.0.1
Subnet Mask: 255.255.255.0
DHCP enabled = Yes
DHCP Scope = 192.168.0.10 to 192.168.0.99

Site 2, Router 2:
LAN IP: 192.168.0.100
SM: 255.255.255.0
DHCP enabled = Yes
DHCP Scope = 192.168.0.110 to 192.168.0.199

Each site's DHCP settings would of course include their router's LAN IP as the default gateway. (ie: Site 1 - DG = 192.168.0.1, Site 2 - DG = 192.168.0.100)

It matters not how straight the gate,
How charged with punishments the scroll,
I am the master of my fate;
I am the captain of my soul.

***William Henley***


Report •

Related Solutions


Ask Question