It is a network issue: the remote location must in the same network as where your/user computer sits. If the remote location is not part of your intranet, it has be reachable as if it is part of the intranet, for example, via VPN. Also, even the access file is located in a a network folder of the same intranet, you/user must be given proper permission to access it. You'll need an network expert to look your network setup to see how or if possible to access the remote location.
Also, directly connect even MS Access in your local drive from AutoCAD, well doable, might not be good option, considering the need to install 64-bit MS Access DB engine.