I'm trying to connect to MS Access database (.mdb) with pyodbc. The following connection string works properly:

```
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};'
                      r'DBQ=\\abc123.org\Team\Resources\Inputs\Accounts.mdb;')

```

I need to iterate over several files, so I'm trying to pass a variable in for the file path. Variables will come from a list but as an example:

```
file_path1 = '\\abc123.org\Team\Resources\Inputs\Accounts.mdb'

conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ={};').format(file_path1)

```

I receive the following error:
Error: ('HY000', '[HY000] [Microsoft][ODBC Microsoft Access Driver] Not a valid file name. (-1044) (SQLDriverConnect); [HY000] [Microsoft][ODBC Microsoft Access Driver] Not a valid file name. (-1044)')

I receive the same error when trying:

```
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=%s;') % file_path1

```

Would appreciate any help on how to pass the file path as a variable in the connection string, thank you!