Transaction Processing

Home | Previous Page | Next Page The Connection and Session Options > Choosing the Connection Option >

Transaction Processing

A database that has transaction logging prompts you to confirm or roll back any transactions when you explicitly disconnect from the current database environment or when you connect to another environment, which forces DB–Access to close an open database. The TRANSACTION menu appears, as Figure 120 shows.

Figure 120. The TRANSACTION Menu for Databases with Transactions

TRANSACTION:   Commit   Rollback
Commit the current transaction.

---------------- moorea@coral ---------------- Press CTRL-W for Help --------

The TRANSACTION menu ensures that you either commit or roll back an active transaction before you close the current database. You have the following menu options:

The default is Commit. Press RETURN, and DB–Access commits the transaction and closes the database.
If you want to roll back the transaction, use an arrow key to move the highlight to the Rollback option. Press RETURN and DB–Access rolls back the transaction and closes the database.

Warning:

Select an option carefully. You might commit transactions that you do not want if you select Commit. You will lose any new transactions if you select Rollback.

If you press the Interrupt key, DB–Access displays the DATABASE menu without committing or rolling back the transaction.