For Access the code has to have access to the machine where the database resides. If you do not have a way to share the drive remotely then the other options are. Remote desktop, 3rd party software...