connect to ms access from sql server using odbc connection code example

Example: r dbConnect(odbc::odbc() to ms sql server remote

library(odbc)con <- dbConnect(odbc(),                 Driver = "SQLServer",                 Server = "mysqlhost",                 Database = "mydbname",                 UID = "myuser",                 PWD = rstudioapi::askForPassword("Database password")                 Port = 1433)