我想通过按钮控件的单击事件完成DataGrid控件中所有数据的清空,也就是说想一下把数据库中某个表的数据全部删掉,该怎么写呢,请大家指教!

Dim db As Database
Set db = Workspaces(0).OpenDatabase(App.Path & "\yyjxc.mdb")
Dim sql As String
Private Sub Comdj_Click()
sql = "delete * from kc "
db.Execute sql
End Sub
这样就可以了

哦，谢谢了