Skip to main content

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 – let us know how we can improve!