You need to use a
Transactionscope[
^]
try
using Trans as new transactionScope()
Trans.commit()
end using
catch ex as TransactionAbortedException
messagebox.show ex.message
end catch
queries are not commited to the database until the
commit
is called. If an error is trapped then the queries are rolled back.
Simon