引用ADO("工程"/"引用"/Microsoft ActiveX Data Object 2.X Library) Private Sub Command1_Click() Dim cn As New ADODB.Connection cn.ConnectionString = Adodc1.ConnectionString cn.Open cn.Execute ("delete from 表") cn.Close Set cn = Nothing End Sub如果你一定要用Adodc来做,只能用循环来删除了
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
cn.ConnectionString = Adodc1.ConnectionString
cn.Open
cn.Execute ("delete from 表")
cn.Close
Set cn = Nothing
End Sub如果你一定要用Adodc来做,只能用循环来删除了
ADODC1.Recordset.ActiveConnection.Execute "DELETE FROM tablename"