Connection to Access File

image_pdfimage_print

Microsoft Access databases can be accessed for read and write access with a connection of type “Access”. Current MS Access versions up to MS Access 2016 are supported.

Main settings:

Database file:

The full path to the Access database file (accdb file)

Username:

DEPRECATED – not used anymore

Password:

Password for the connection to the database (optional)

Note: the Access connection internally uses the UCanAccess JDBC driver with following implications:

  • Column names are changed in the UCanAccess Jdbc to uppercase. This is required for the JDBC internal algorithm. This may change in newer versions of the JDBC; please refer to http://sourceforge.net/p/ucanaccess/discussion/help/thread/ed3465a0.
  • Some special characters in column names (e.g “?”) will be replaced with the underscore character. Some enhancements are planned to avoid this in newer versions of the JDBC.
  • There are some limitations in the SQL function IIF: Not all of the types are supported as 2nd and 3rd arguments.
image_pdfimage_print
Was this post helpful?
NoYes (-5 rating, 5 votes)
Loading...