'在保存时使用事务: private sub cmdsave_click() on error goto errsave conn.begintrans '开启事务 conn.execute "insert into ..." conn.execute "insert into..." conn.execute "update ..." conn.committrans '提交事务 exit sub '错误处理 errsave: conn.rollbacktrans '回滚事务 msgbox "保存失败!",48,"提示" exit sub end sub
BeginTrans
....
CommitTrans '成功RollBackTrans '失败
private sub cmdsave_click()
on error goto errsave
conn.begintrans '开启事务
conn.execute "insert into ..."
conn.execute "insert into..."
conn.execute "update ..."
conn.committrans '提交事务
exit sub
'错误处理
errsave:
conn.rollbacktrans '回滚事务
msgbox "保存失败!",48,"提示"
exit sub
end sub