Marks the starting point of a user-defined transaction.
begin tran[saction][transaction_name]
is the name assigned to the transaction. It must conform to the rules for identifiers. Use transaction names only on the outermost pair of nested begin transaction/commit or begin transaction/rollback statements.
begin transaction
The access service library accepts the transaction name parameter, then strips it before passing it to the target.
The begin transaction command is not recognized by ODBC, so the DirectConnect server traps this statement and monitors the transaction state internally. When a commit is issued after a begin transaction, SQL Transact() is called.
Only one transaction can be open for each connection.
