直接用 ADODB.CONNECTION 来操作ADODB.CONNECTION.EXECUTE "DELETE FROM TABLENAME"
Dim rs As DAO.RecordsetSet rs = db.OpenRecordset("SELECT * FROM 表名")
呵呵,没有理解。Private Sub Form_Load() Dim db As Database Dim rs As DAO.Recordset Set db = OpenDatabase(App.Path & "\Test.mdb") Set rs = db.OpenRecordset("DELETE * FROM 表名")End Sub不过我不推荐这么做。
║ ║
║ 免费的学习、交流、源码、工具网站,欢迎大家访问! ║
║ http://www.j2soft.cn/ ║
╰════════════════════════════╯
truncate table tablename
db.Execute "DELETE FROM 表名"
db.Close
Set db = Nothing
Dim db As Database
Set db = OpenDatabase(App.Path & "\Test.mdb")
db.Execute ("delete from table1")
End Sub
Dim db As Database
Dim rs As DAO.Recordset
Set db = OpenDatabase(App.Path & "\Test.mdb")
Set rs = db.OpenRecordset("DELETE * FROM 表名")End Sub不过我不推荐这么做。