You have little choice then.

You could redesign everything to use a proper Cloud platform (and that means you cannot use an ACE or Jet database).

Or else you might go with a hosted ASP application as already suggested, which still requires a redesign but at least you can still use a Jet MDB or ACE ACCDB.

I suspect you will find it less work in the long run though to move to a hosted client/server DBMS like SQL Server or MYSQL. The downside is that even to use those with your monolithic application design you have to find a hosting provider that permits client connections from the public Internet. Most hosting providers do not allow this, but some do.

So those are your three options if your friend insists on this requirement: massive rewrite, significant rewrite, or move to a client/server DBMS on a remote host allowing client connections.

Very few people ever take the first path with VB6. These days very few take the second path using ASP. Almost everyone either tries the third path or gives up and installs a file server on their LAN.