access_dbconnection: Connection with Access database

In OB7-IRD/furdeb: FUnctions for R DEvelopment and Beyond!

Connection with Access database

Description

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

Usage

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

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.

Value

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

OB7-IRD/furdeb documentation built on June 28, 2023, 5:59 p.m.