先要引用:Microsoft ActiveX Data Object 2.0 Library 这是一个连接ACCESS数据库的例子: Dim db As ADODB.Connection Dim rs As ADODB.RecordsetPrivate Sub Form_Load() Set db = New Connection db.CursorLocation = adUseClient db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\data.mdb;Persist Security Info=False;" Set rs = New Recordset strsql = "select * from table" rs.Open strsql, db, adOpenDymanic, adLockBatchOptimistic End Sub
这是一个连接ACCESS数据库的例子:
Dim db As ADODB.Connection
Dim rs As ADODB.RecordsetPrivate Sub Form_Load()
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\data.mdb;Persist Security Info=False;"
Set rs = New Recordset
strsql = "select * from table"
rs.Open strsql, db, adOpenDymanic, adLockBatchOptimistic
End Sub