PLZ. HELP with remote DB

[mendhak]

Connecting to an Access db over the Internet is a bad idea, but anyways:

Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
 
Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset
 
Debug.Print cnn.State
cnn.Open "Provider=MS Remote;Remote Server=http://myServer;" _
            & "Remote Provider=Microsoft.Jet.OLEDB.4.0;" _
            & "Data Source=c:\inetpub\wwwroot\biblio.mdb;admin,"
Debug.Print cnn.State
 
rs.Open "SELECT * From Authors", cnn, adOpenKeyset, adLockOptimistic
 
Debug.Print rs.RecordCount

Try it out. If it doesn't work, I doubt anything's possible for that matter.