Dim Conn As ADODB.Connection
Dim Rst As ADODB.Recordset
Conn.CursorLocation = adUseClient
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB4.0;Persist Security Info=False;Data Source=" & App.Path & "\LL.mdb;Jet OLEDB"
Rst.Open "Select * From Table", , adOpenStatic, adLockOptimistic
Dim Rst As ADODB.Recordset
Conn.CursorLocation = adUseClient
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB4.0;Persist Security Info=False;Data Source=" & App.Path & "\LL.mdb;Jet OLEDB"
Rst.Open "Select * From Table", , adOpenStatic, adLockOptimistic
Set card = DBEngine.OpenDatabase("card.mdb")
'用特定的筛选条件(MyRecordSource)连接特定的数据库(MyDatabase)两个参数来连接数据库中的某张表(MyTable),数据库的密
'码为DataBasePassword
'并指定特定的字段(MyFields),返回特定的值,不绑定数据控件Function adoconnect3(ByVal MyDatabase As String, ByVal MyTable As String, ByVal MyFields As String, ByVal MySQLCondition1 As String) As Recordset
Dim MyRs As ADODB.Recordset
Dim MyConnectString As String
Dim sql As String
''' 打开连接。
MyPath = getapppathparent + "database\"
MyConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & MyPath & MyDatabase & ";Jet OLEDB:Database Password=" & DataBasePassword
Set MyCnn = New ADODB.Connection
MyCnn.Open MyConnectString
''建立RecordSet
Set MyRs = New ADODB.Recordset
sql = "SELECT " & MyFields & " FROM " & MyTable & MySQLCondition1
MyRs.CursorLocation = adUseClient
MyRs.LockType = adLockBatchOptimistic
MyRs.CursorType = adOpenKeyset
''给函数赋值
MyRs.Open sql, MyCnn
Set adoconnect3 = MyRs
End Function
但他在模块中却可以这样声明:public db as Database
而我在模块中却不能这样声明(根本上没有Database 这个先择)。
请问:为什么?????
为什么????
但他在模块中却可以这样声明:public db as Database
而我在模块中却不能这样声明(根本上没有Database 这个先择)。
请问:为什么?????
为什么????
现在很少有人用DAO 了