Hello again,
im still trying to build VB program which will connect DB via remote connection, now here is the code i use:


Dim rs As New ADODB.Recordset
Dim cn As New ADODB.Connection
cn.Open "Provider=MS Remote;Data Source=1.mdb;" & _
"Remote Server=http://www33.brinkster.com/acagl/"
rs.Open "SELECT * FROM authors", cn

i use brinkster free DB access, the DB located here:
http://www33.brinkster.com/acagl/1.mdb
it works u can check, now this code give me INVALID SERVER ERROR, im trying to solve this problem for 2 weeks now please if any one know how to connect the DB and have done it before reply me.

thanks and happy new year!