Is there a method to connect to an MS Access database file (.mdb) using QGIS?
In particular I need to connect to a query in it.
The database does not have spatial data.
[GIS] Connecting QGIS to query on MS Access database
ms accessqgis
Related Solutions
You should be able to use the AccessWorkspaceFactory co-class even though it's not a personal geodatabase. You could also use ADO.NET. I am not sure why your code isn't working but I do know that working with property sets is an exercise in frustration.
Note there are two ways of doing this. The way you are going about doing it is the long way but that is the way I am going to show how to do it here. The other way is by just going to Add Vector Layer and then selecting file and then browsing to where your .mdb file is located and opening the .mdb file.
First, you need to make sure QGIS 32 bit version is being used. Download and install QGIS for Windows 32 bit. You need a 32 bit version of QGIS because Microsoft does not make a 64 bit driver for Access(.mdb). Esri ArcMap is 32 bit too so it can work with .mdb files.
Second, you need to create a DSN(Data Source Name). To create a DSN, Go to your start button and click it.
Next in the search box, type %windir%\SysWoW64\odbcad32.exe and click on the odbcad32.exe program.
Click on the System DSN tab
Click on the add button to add a dsn so ODBC and Esri Personal Database.mdb can be accessed. Once you click on the Add button a new dialog will appear. On this dialog, select Microsoft Access Driver(*.mdb) and click finish.
After clicking finish, another dialog will appear. In this dialog, put QGIS for the Data Source Name.
Next click on the Select button under Databases. Once you select this button, another dialog will appear.It is the select database dialog.
On this dialog, you need to navigate to your .mdb file. Once you are in the folder the .mdb file will appear in the left box. Select your .mdb file and click OK
Now you should see the ODBC Microsoft Access Setup Dialog. The Dialog should show you your .mdb file like the dialog box below.
Now click OK on the dialog box. Also make note, the DATA Source Name is QGIS. We will use this name when setting up an ODBC .mdb / Esri Personal GeoDatabase.mdb. Once you click ok you should see a dialog box like the following, which shows the DSN you just created. Click ok on this dialog box to close it out.
Now open up QGIS 2.4 and go to Add Vector Layer
Now, Select database and then select your Encoding you want and then under Database Type select Esri Personal GeoDatabase
Now, on the same dialog, click the New Button
A new dialog box will appear. On this dialog box, fill out the Type, Name and Database fields. For the Type field, select Esri Personal GeoDatabase. For the Name, type whatever you want. For the Database field, type QGIS. Note that QGIS is the same name as the DSN that we created earlier.
Now click on the test button.
If everything is setup correctly, you will see this after clicking on the test button.
Next click ok to close out the test and then click Ok to finish the database connection.
Now you should see the name you gave the connection and once you do, click the Open Button. Once you click open, it will ask for a password. Just click ok, unless the database has a password.
After clicking ok on the password dialog box, you will see a dialog like below:
Select your layer and click ok. After selecting the layer you want and clicking ok you will see another dialog box. This dialog box is for setting coordinate references.
And we are done! You can do this with regular .mdb or Esri Personal GeoDatabase. To do it this way, you need to create a DSN and then set up a connection. There is a simpler way and that is just by going to add vector and making sure File is selected and then just browsing to your .mdb. Note, you need QGIS 32 bit to work with .mdb databases.
Best Answer
It's possible to connect via ODBC.