Microsoft Access (JDBC) Writer Parameters
Database Connections |
---|
Connections store authentication information. For general information about sharing database connections, please see Using Database Connections. Note that different subsets of Database Connection parameters are made available in different contexts. ![]() Select an existing connection, or Add Database Connection to define a new connection. The new connection can be made visible only to the current user, or can be shared among multiple users. |
Database Connection

The name of the database to connect to.

This format does not yet support creating a database with a password. Use the Windows-only Microsoft Access format instead, or ensure that this parameter field is clear.

The version of the database to create.

- If this option is unchecked (default) and a database already exists, then tables and features are written to the existing database.
- If this option is checked, any existing database is deleted before writing begins.
If no database exists when writing begins, a new database is created.
Note: After a database is deleted, it cannot be recovered – all data is lost.

This parameter is available only when Overwrite Existing Database is enabled.
A template file implies that the database will be overwritten (replaced) before any table handling operations are performed.
If a template file is specified, the writer will make a copy of the template file in the location specified in the Database Path parameter. All operations will be performed on the copy while the template file remains unchanged.