¿Con "remoto" te referís a algo como
http://otro-servidor.com/db/base.mdb ?
Si es así, creo que esto te sirve:
Cita: If your Access database is on another server, you will need to ensure that Jet 4.0 is installed on the remote server, and that you know the *local* location of the MDB file on that server. Once you have those two vital pieces, you can use a connection string like this (
see Article #2168 for more details):
<%
cst = "Provider=MS Remote;" &_
"Remote Server=http://<ip/server name>;" &_
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=c:\inetpub\wwwroot\file1.mdb;"
set conn = CreateObject("ADODB.Connection")
conn.open cst
%>
(And I feel sorry for you. Access is not really up to this task, as I'm sure you'll quickly learn.) (Fuente:
http://www.aspfaq.com/show.asp?id=2126)
Pero prestale atención a lo que está en rojo