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. Connection
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.