Microsoft Access Database Metadata Tables Query from ADF

Question

We have a requirement for automatic metadata capture (List of tables and columns) from Microsoft Access Database Tables. For this, we need to query the MS Access Database metadata tables to get the details.

As part of our project requirements, we have implemented the same for Microsoft SQL Server tables.

When we tried to query the "information_schema.tables" and "informaton_schema.columns" from ADF lookup activity which points to MS Access Database (Northwind.mdb) Dataset, we get the following error.

Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\Program Files\Microsoft Integration Runtime\4.0\Shared\information_schema.mdb'.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\Program Files\Microsoft Integration Runtime\4.0\Shared\information_schema.mdb'.,Source=ACEODBC.DLL,'

But, we could able to query the Microsoft Access Database metadata tables from the client tools like DBeaver. Attached the screen shot for DBeaver queries.

Could you please help us in extracting the MS Access metadata tables from ADF lookup activity ?