Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command
Private Sub Form_Load()
conn.Open "Dsn=data" '我用的是系统dsn 打开连接
On Error Resume Next
conn.BeginTrans
cmd.ActiveConnection = conn
cmd.CommandText = "insert 表1 (name) values ('张三')"
cmd.Execute
cmd.CommandText ="insert 表2 (name) values ('张三')"
cmd.Execute
cmd.CommandText ="insert 表3 (name) values ('张三')"
cmd.Execute
If conn.Errors.Count = 0 Then
conn.CommitTrans
Else
conn.RollbackTrans
End If
End Sub
如果sql语句很多,可以将SQL语句写成数组;用for循环执行!