和指定数据库的连接问题
Private Sub Command1_Click()
Set rs1 = New ADODB.Recordset
(?Set db = New ADODB.Connection?)
rs1.Open "select * from base where 级别='" & Text1.Text & "'", ConnMain, adOpenStatic, adLockReadOnly
If rs1.EOF Then
n = MsgBox("无此信息!", vbInformation)
Text1.Text = ""
Text1.SetFocus
Else
Set DataGrid1.DataSource = rs1
End If
End Sub
错误,无法连接。连接以被关闭或无效
Set db = New ADODB.Connection
db.ConnectionString = ?
db.Open
如何建立指定连接,连接到指定的Access数据库几种方法,请指教。并请解释。