Access components

tAccessBulkExec	Offers gains in performance when carrying out Insert operations in an Access database.
tAccessClose	Closes an active connection to the Access database so as to release occupied resources.
tAccessCommit	Commits in one go a global transaction instead of doing that on every row or every batch, and provides gain in performance, using a unique connection.
tAccessConnection	Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.
tAccessInput	Reads a database and extracts fields based on a query.
tAccessOutput	Writes, updates, makes changes or suppresses entries in a database.
tAccessOutputBulk	Prepares the file which contains the data used to feed the Access database.
tAccessOutputBulkExec	Executes an Insert action on the data provided, in an Access database.
tAccessRollback	Cancels the transaction commit in the connected database and avoids to commit part of a transaction involuntarily.
tAccessRow	Executes the SQL query stated onto the specified database.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!