title: Relative path to access database
body: <p>I hope some one here can point me on the right direction.
  I am trying to connect to an access database from R without hardcoding the path to it. For instance this works when I write the path:</p>
  
  <pre><code>library(RODBC)
  library(dplyr)
  library(dbplyr)
  library(DBI)
  library(tibble)
  
  myDB &lt;- odbcDriverConnect("Driver={Microsoft Access Driver (*.mdb, 
  *.accdb)};DBQ=C:/Users/myfolder/Desktop/R_Connection.accdb")
  
   #But this doesn't work. I put the database path in 'dbpath' but for some
   #reason 'dbpath' isn't recognized.
  
  dbpath &lt;- paste0(getwd(),"/R_Connection.accdb")
  print(dbpath)
  myDB &lt;- odbcDriverConnect(paste0(""Driver={Microsoft Access Driver (*.mdb, 
  *.accdb)};DBQ="",dbpath))
  </code></pre>