how? please tell me

[mabzkie]

how to connect to a remote database using an ado? what are the codes? someone help me please.

[sashi]

how to connect to a remote database using an ado? what are the codes? someone help me please.

Hi there,

Kindly refer to below, change your connectiong string as below, hope it helps. Good luck & Take care.

oConn.Open "Provider=MS Remote;" & _ 
           "Remote Server=http://myServerName;" & _
           "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\mydb.mdb", _
            "admin", ""

[mabzkie]

thank you for the code, i tried it but there's an error "cannot connect to server." so what do you think is wrong?