I'm prepared to be shot down in flames but I believe that Access is a file based RDBMS (whereas SQL Server is network based) so to connect to it over a network you must have permission to access the server/folder containing the database.
Assuming you have access to the relevant folder you can use ADO to connect by using a connection string in the format of:
Where strDbPath is like "F:\MyDbFolder\MyData.Mdb" [using mapped drive F:] or "\\NetwokServer\SharedFolder\MyData.Mdb"
CnxString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Persist Security Info=False;" & _
"Data Source=" & strDbPath & _
Edit this to your particular requirements.