Connecting QGIS to query on MS Access database?

Question

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.

Answer 1

It's possible to connect via ODBC.

• In windows, start the ODBC Administrator and define your Datasource (Microsoft Access Driver).
• In QGIS go to Layer/Add Layer/Vector Layer/database: Type=ODBC.
• Set up a new Connection. Host should be "localhost" if your database is local on your machine. Database Name is the same name you defined before in the ODBC Administrator.

Answer 2

... or directly with MS Access Forms ...

There is a simple way:

You are able to define an action for each layer (see: Layerproperties). There you can input a Python script.

from win32com.client import Dispatch

dbname ="dbname.mdb"

dbForm = "frmname"

filter ='id= "[% "ID" %]"'

a=Dispatch("Access.Application")

a.Visible=True

objDB = a.CurrentDb()
            
if objDB is None:

    a.OpenCurrentDatabase(dbname,True)

a.DoCmd.OpenForm(dbForm)

a.forms(dbForm).Filter = filter

a.forms(dbForm).FilterOn = True