Connection with Access database

Source: R/access_dbconnection.R

Generate a common connection with an Access database using a JDBC driver.

access_dbconnection(
  driver_name = "u_can_access",
  access_database_file_path,
  access_jdbc42_driver_file_path = NULL
)

Arguments

driver_name

character expected. By default "u_can_access" (free driver). Access driver name. You can also choose the driver "access_jdbc42" (paid driver).

access_database_file_path

character expected. file path of the Access database (.mdb or .accdb expected).

access_jdbc42_driver_file_path

character expected. By default NULL. File path of the access_jdbc42 driver (.jar file expected). Mandatory if "access_jdbc42" is selected in the argument "driver_name".

Value

The function return a R object with Access database identification of connection.

Details

Difference between drivers "u_can_access" and "access_jdbc42":

  • "u_can_access": the main advantage is it's a free java JDBC driver. To understand briefly the process behind, the Access database is converted in HSQLDB system. This conversion could take a long time, especially if the database if large. Furthermore, after the conversion, queries should be faster than if there run on an Access database.

  • "access_jdbc42": this driver is paying. In opposition with the "u_can_access" driver, the Access database is not converted. The connection should be faster but the queries could be longer.