Jump to content

Accessing MS Access Database over WAN

antoainb
By antoainb
in Networking
 Share
Posted

So here's what I need:

 

My dad made an Access database for a friend of his who runs a small business, so that he could keep an inventory of his things. He has three places from which he wants to be able to access the database from: from home and from his two offices.

 

I have looked and looked and most things I find haven't been working so well for me.

Here's what i have tried:

  • PPTP VPN to connect to home network and access a SMB/Samba share - waaaaaay too slow
  • WebDAV server - very slow, faster than PPTP+SMB but still unusable when using the database.

I'm currently testing this at home and my upload is 8Mb/s, not blazing fast but also not the bottleneck, as transfer speeds stay in the low KB/s.

 

If you know one or two things about networking and stuff like this please help me, any help is greatly appreciated.

 

Thanks in advance!

i'm a potato

Link to comment
https://linustechtips.com/topic/409746-accessing-ms-access-database-over-wan/
Share on other sites
Link to post
Share on other sites
Posted

So here's what I need:

 

My dad made an Access database for a friend of his who runs a small business, so that he could keep an inventory of his things. He has three places from which he wants to be able to access the database from: from home and from his two offices.

 

I have looked and looked and most things I find haven't been working so well for me.

Here's what i have tried:

  • PPTP VPN to connect to home network and access a SMB/Samba share - waaaaaay too slow
  • WebDAV server - very slow, faster than PPTP+SMB but still unusable when using the database.

I'm currently testing this at home and my upload is 8Mb/s, not blazing fast but also not the bottleneck, as transfer speeds stay in the low KB/s.

 

If you know one or two things about networking and stuff like this please help me, any help is greatly appreciated.

 

Thanks in advance!

Download Teamviewer and install it on both computers. 

CPU: AMD Ryzen 5 5600X | CPU Cooler: Stock AMD Cooler | Motherboard: Asus ROG STRIX B550-F GAMING (WI-FI) | RAM: Corsair Vengeance LPX 32 GB (4x 8 GB) DDR4-3000 CL16 | GPU: Nvidia GTX 1060 6GB Zotac Mini | Case: K280 Case | PSU: Cooler Master B600 Power supply | SSD: 1TB  | HDDs: 1x 250GB & 1x 1TB WD Blue | Monitor: 24" Acer S240HLBID | OS: Win 11 Pro.

 

Home Lab:  Lenovo ThinkCenter M82 Hyper-V Server 2022 | Dell OptiPlex 9020 Hyper-V Server 2022 | TP-LINK TL-SG108E | Cisco Catalyst C2960CG 8 Port Switch | HP MicroServer G8 SCCM Server | 2x Dell PowerEdge R630 Hyper-V Server 2022

 

 

Link to post
Share on other sites
Posted
  • Author

Download Teamviewer and install it on both computers. 

 

That has one disadvantage though, it only supports one user at a time and he might have people on both offices using it. It is an option though, if all else fails.

i'm a potato

Link to post
Share on other sites
Posted

All thought it might be a bit of a pain, I would suggest making a little website in which the people can login and edit the database from.

The advantage of this is that they could do it from anywhere, and you can safely have multiple people editing stuff at once.

15" MBP TB

AMD 5800X | Gigabyte Aorus Master | EVGA 2060 KO Ultra | Define 7 || Blade Server: Intel 3570k | GD65 | Corsair C70 | 13TB

Link to post
Share on other sites
Posted
  • Author

All thought it might be a bit of a pain, I would suggest making a little website in which the people can login and edit the database from.

The advantage of this is that they could do it from anywhere, and you can safely have multiple people editing stuff at once.

I found a way to use RDC and be able to have multiple users logged in and it seems to work pretty well.

Still I might look into your suggestion, do you have any idea how I could do that?

 

Blade of Grass

i'm a potato

Link to post
Share on other sites
Posted

I found a way to use RDC and be able to have multiple users logged in and it seems to work pretty well.

Still I might look into your suggestion, do you have any idea how I could do that?

Blade of Grass

Yeah, you'd need to setup an IIS server. Then you'd need to make a website in ASP to interact with the database.

15" MBP TB

AMD 5800X | Gigabyte Aorus Master | EVGA 2060 KO Ultra | Define 7 || Blade Server: Intel 3570k | GD65 | Corsair C70 | 13TB

Link to post
Share on other sites
Posted (edited)
  • Author

Yeah, you'd need to setup an IIS server. Then you'd need to make a website in ASP to interact with the database.

 

That would be significantly more complicated. I have no experience with any of those tools, so I'd need to do my fair share of homework. Since I'm a total noob I do have questions:

 

  • Would it use the access database's forms and everything or not? (basicaly, would it or could it have a GUI in any way shape or form similar to this: http://imgur.com/a/2CcRU)
  • Do I need Windwos Server for IIS or can I use it with normal Windows, I can't buy Windows Server so I'd basically have two options. If it would work with a Linux OS I'd use that, if not then:

 

Also, if you could point me to any documentation (tutorials and stuff like that) that could help with doing this I'd be very thankful.

 

I think that's all, thanks for your help Blade of Grass.

 

edits: fix spelling, add imgur link, add spoiler

Edited by antoainb

i'm a potato

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Networking

×