VB Connection String Help wanted..........!!!!!!!!!!

[rajivd]

Can i access my database (*.mdb file), which is on a free web site (http://geocities.com/XYZ/XYZ.mdb).
through Visual Basic 6.0.
If yes , what is the connection string required.

[TH1]

Try this

Dim oconn as ADODB.Connection
set oconn = new ADODB.Connection
oconn.Open "Provider=MS Remote;" & _
"Remote Server=http://www.geocities.com;" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\XYZ\XYZ.mdb;", _
"admin", ""