用ADO,它有事务回滚,执行一出错后可将前面已执行的操作取消!
dim Con as New ADODB.Connection
Con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog="+数据库名+";Data Source="+服务器名+";password="+登录密码+";"
MDI.Con.BeginTrans
Con.Execute "delete table1"
If Err.Number = 0 Then
Con.CommitTrans
MsgBox "保存成功!"
Else
Con.RollbackTrans
MsgBox "保存失败!"
End If