Set dcnPassword = New ADODB.Connection
With dcnPassword
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\sys.mdb;"
.Open
End With
Set rsPassword = New ADODB.Recordset '打开记录集。
With rsPassword
.Open "SELECT * FROM [Password] where [Security] in('all','仓储')", dcnPassword, adOpenStatic, adLockOptimistic
'移动到记录尾部获得记录号,然后返回,以便获得总记录数。
.MoveLast
.MoveFirst
Do While Not .EOF
Combo1.AddItem ![UserName]
.MoveNext
Loop
End With
With dcnPassword
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\sys.mdb;"
.Open
End With
Set rsPassword = New ADODB.Recordset '打开记录集。
With rsPassword
.Open "SELECT * FROM [Password] where [Security] in('all','仓储')", dcnPassword, adOpenStatic, adLockOptimistic
'移动到记录尾部获得记录号,然后返回,以便获得总记录数。
.MoveLast
.MoveFirst
Do While Not .EOF
Combo1.AddItem ![UserName]
.MoveNext
Loop
End With
Dim rs As Recordset
Set db = OpenDatabase(App.Path + "\数据库.mdb")
Set rs = db.OpenRecordset("表名")
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=库.mdb;Jet OLEDB:Database Password=密码"