Database link problem

[qiaojun]

Can VB6 link with Office Access 2000 or even Office XP Access?

[Iouri]

Dim sConn As String
Dim cn as ADODB.Connection

Set cn = New ADODB.Connection

sConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DBNAME & ";Persist Security Info=False"
cn.ConnectionString = sConn
cn.Open sConn

thta will connect you to Access db. Now you can create recordset and do anything you want

Iouri Boutchkine
iouri@hotsheet.com