请问:怎样用VB ADO来实现对Access数据库表删除的操作?

跟对SQL操作一样的啊。用COMMADN执行SQL语句

sql="delete from xxxx where xxxxxxx"

谁能给一段完整的代码,要是ADO实现的,否则就没有用,帮帮忙把

ding

删除记录还是删除表？

Dim oCnn As Object
Dim s_Sql As String
Set oCnn = CreateObject("ADODB.connection")
oCnn.connectionstring = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=sa;Initial Catalog=zw"
oCnn.ConnectionTimeout = 30
oCnn.Open
s_Sql="delete from xxxx where xxxxxxx"
oCnn.Execute (s_Sql)
Set oCnn=Nothing

删除表呀,要通过ADO实现的,其他的我也会

Dim oCnn As Object
Dim s_Sql As String
Set oCnn = CreateObject("ADODB.connection")
oCnn.connectionstring = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=sa;Initial Catalog=zw"
oCnn.ConnectionTimeout = 30
oCnn.Open
s_Sql="drop table temp"
oCnn.Execute (s_Sql)
Set oCnn=Nothing

我怎么都觉得上面的解答给得很全了……删除表和删除记录有很大区别吗？（技术难度上）