1,216
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
Dim cnn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rs As ADODB.Recordset
Private Sub Form_Activate()
Dim sql1 As String
Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\glnhpj.mdb;Persist Security Info=False"
sql1 = "select * from user"
Set cmd.ActiveConnection = cnn
cmd.CommandType = adCmdText
cmd.CommandText = sql1
rs.Open sql1, cnn, adOpenKeyset, adLockOptimistic
Text1.SetFocus
End Sub
Public adocon As New ADODB.Connection
Public adors As New ADODB.Recordset
'Public cmd As New ADODB.Command
Public Function cn() As ADODB.Connection '定义返回一个数据库连接
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\glnhpj.mdb;Persist Security Info=False"
End Function
Option Explicit
Dim cnn As New ADODB.Connection '数据库连接对象
Dim rs As New ADODB.Recordset '记录集对象
'有这二个对象足矣
Private Sub Form_Activate()
Dim sql1 As String
Call cn(cnn)
sql1 = "select * from user"
rs.Open sql1, cnn, adOpenKeyset, adLockOptimistic
'数据表操作语句
rs.Close '关闭记录集对象
cnn.Close '关闭数据库连接对象
End Sub