SSIS Components for Microsoft Access

Build 24.0.9060

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
CreateNewDatabaseSpecifies what format shoud be used by a new database file created when the file specified by connection property DataSource does not exist.
IncludeMSysTablesSet this property to the true value to allow querying from the system tables.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
OtherThese hidden properties are used only in specific use cases.
ReadonlyYou can use this property to enforce read-only access to Microsoft Access from the provider.
RTKThe runtime key used for licensing.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060