Using an Access database over vpn

My shared database works well over an internal network, but is practically unusable over the vpn connection. Are there any guidelines about data transfer speed required for using an Access database over vpn? Current transfer speed on the vpn is only around 10Mbytes per minute.

Typically, you use a VPN connection when you are not connected to your LAN, and thus connection over a WAN for which Access is not an option.  Access databases are solely made to be used over wired LAN connections.

Look over

http://www.devhut.net/2012/08/14/ms-access-wans-wireless-networks-and-the-internet/ (there is reference there to an article by Albert Kallal in which he breaks down some numbers and speed comparisons)

http://www.devhut.net/2016/09/24/access-back-end-location-wan-online-server-onedrive-dropbox/ (specifically the alternaive section of the article)

http://www.devhut.net/2017/04/09/setting-up-an-ms-access-database/

--
Daniel Pineault
Microsoft MVP 2010-2024

11 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 14, 2025 Views 14,069 Applies to: