Today's post was written by Juan Soto, a Microsoft Access Developer and MVP.
Ever wanted to use your Access database remotely? Great news, Microsoft Access can be used remotely under certain conditions, and here are the best ways to do so:
Remote Desktop: The easiest and fastest way to remotely consume your database is through a remote desktop software; from Microsoft’s Remote desktop to other commercial software that will allow you to take over your work PC remotely and continue using the database as if you were in the office (See Get Microsoft Remote Desktop and How to Use Remote Desktop)
If you haven’t already, upgrade your database to SQL Server in order to leverage the power of SQL with Access; you can find more info on it HERE: please note you may need to create SQL Server views and stored procedures based on the complexity of your Access database, and although occasionally timely, this is certainly a worthwhile effort.
VPN: If your database is composed of both Microsoft Access Front End and a SQL Server backend, than make sure you are running the Front End file on your local PC after you connect via VPN to work, otherwise it may be slower and unreliable.
About the Author:
Juan Soto is the President of IT Impact and a leading professional in the industry. He has been named an Access MVP by Microsoft since 2011 and is a frequent author on the official Microsoft Access blog as well as the co-founder of AccessUserGroups.org, where groups of Access enthusiasts around the world meet once a month on a wide range of topics. You can reach Juan at https://accessexperts.com/contact/