odbcDriverConnect issue trying to connect to an Access Database in R -

i using r 32 bit , having issue trying odbcdriverconnect function work when trying connect access database. have connect database using odbcconnect, trying learn how use odbcdriverconnect function.

my code is

scallopdata<-odbcdriverconnect("driver={microsoft access driver (*.mdb, *.accdb)};dbq=s://adv/scallop central/2014 rsarr/2014 rsa database_9_3_2014.mdb;     uid=admin;pwd=")   

when run code, error message of odbc microsoft access driver login failed. not find file s://adv/scallop central/2014 rsarr/2014 rsa database_9_3_2014.mdb.

i click ok button takes me login box. select database... button. brings me select database box can select same database specified in dbq section of code. once select correct database , click ok connected database.

i hoping use odbcdriverconnect function not have set new odbc dsn each database access. may me not understanding function.

if 1 can provide insight, helpful.