在窗体中加了下面的一段代码:
dim recName as recordset
recName=currentdb.openrecordset("t1")
't1是数据库中的一张表
'问题出在这,它说类型不对
.
.
我的问题是我上面代码有什么问题?如何将一张表传递给一个recordset?
---------------------------------------------------------------
Give a example as
Private Sub LockTest_Click()
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("Customers", dbOpenTable, dbDenyWrite)
rs.Close
db.Close
Set db = Nothing
Set rs = Nothing
DBEngine.Idle dbFreeLocks
Set db = CurrentDb
Set rs = db.OpenRecordset("Customers", dbOpenTable, dbDenyWrite)
rs.Close
db.Close
Set db = Nothing
Set rs = Nothing
DBEngine.Idle dbFreeLocks
End Sub