Remote Database using ADO
I'm trying to access a database that's sitting on a web server. I can
make the connection, but I can't open a recordset. My code for the
connection is below.
Thanks,
Corey
Private Sub Command1_Click()
Dim C As ADODB.Connection
Set C = New ADODB.Connection
sever = "www.myweb.com"
Source = "c:\temp\mydb.mdb"
cnnstr = "Provider=MS Remote; Remote Server=" & server & ";Remote
Provider=Microsoft.Jet.OLDDB.4.0;Data Source=" & Source & ";admin"
C.Open cnnstr, admin, ""
C.Close
End Sub
