title: Error reading data from MS Access database using RODBC package
body: <p>I've got hundreds of individual MS Access files that contain data on individual locations, each with an identical table structure. Rather than creating one database with all these files, they were all save in different folder locations. I'm trying to wrangle the data into one place so it can be more useful and I'm exploring the RODBC package for R to do that.</p>
  
  <p>I'm using the RODBC package in 32 bit Rstudio to access MS Access databases in file locations which I can open and read from. I can establish the file connections and list out all the table objects for each database, but every time I try to query or read one of the tables I get this error:</p>
  
  <blockquote>
    <p>[1] "42000 -1907 [Microsoft][ODBC Microsoft Access Driver] Record(s)
    cannot be read; no read permission on 'HabitatUnits'." [2] "[RODBC]
    ERROR: Could not SQLExecDirect 'SELECT * FROM HabitatUnits'"</p>
  </blockquote>
  
  <p>I experimented another access data base that I created and I was able to read the data no problem, so it must be a restriction imposed on the other data sets. Is there a way to grant access so that R can read in this data without going through each data base to manually change the accessibility? </p>