Complex Local Access Database - Enable Work from Home

[kasmax]

I think there is a very easy, quick and efficient way that i have been using.
so basically if you have a web hosting with sql server then
convert your access backend to sql server which is very easy and very quick to do. there are many tools available to do that.
then upload or import your converted sql server database to your web hosting.
and finally in you access database frontend use link table manager to link your tables to the online sql server database.

everthing else works as it is and multiple people can use it from internet. all the vba code works as it is.

 

[Minty]

It supports file sharing and local printing as well as dual monitors. It's almost as good as being in the office as long as nothing happens physically to your actual pc like a power outage.

If you are doing this, make sure your PC Bios setting is set to resume On State if it loses power, at least it will turn itself back on.
The Google desktop sharing software lets you log back in remote,y.

 

[zeroaccess]

I've been using Teamviewer for many years for personal use, but they have a paid version for business use.