You mark the beginning of a transaction with the BeginTrans statement. You use the Rollback or CommitTrans statement to end a transaction. Because Visual Basic locks data pages used in a transaction until the transaction ends, using transactions will prevent access to those data pages by other users while the transaction is pending. If you use transactions in a multi-user environment, try to find a balance between data throughput and data access. If database operations are not within a transaction, every Update method causes a disk write.
Transactions are very fast because they are written to a buffer in memory instead of to disk.
CommitTrans writes the changes in the transaction buffer to disk. Robust error trapping is important when using transactions to avoid losing writes if the program gets an error in the middle of a transaction. Form1 is created by default. AddNew 'AddNew clears copy buffer to prepare for new record. Set Telephone field to unique value.