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.
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.