So I am new to the QGIS community, and I have been trying to bring in some rather large access databases with little to no success. I have windows 7, so I've gone in through administrative tools/Data Sources (ODBC) to create a new user DSN. I made it a Microsoft Access Driver (.mdb,.accdb), and linked it to the database I wish to use.
Then in QGIS, I have used add vector layer, selected Database, left type ODBC, given it a name, specified localhost and for Database, written in an identical name to the User DSN I created... BUT... every time I try to test it, it gives the following error:
Connection failed - Check settings and try again. Extended error information: Unable to initialize ODBC connection to DSN for ALC_AV_CO, [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Why is it doing this?
Interestingly enough the only time I had success, I managed to somehow create a User DSN which was a Microsoft Access Driver (*.mdb) without the .accdb (I saved a version of my DB in .mdb to make this work too). However, for reasons unknown to me, this option is no longer available to me in the create new data source menu, so I can't use it again!
I would really appreciate if someone could give me advice on what I am doing wrong!