Access was never a good DBMS it's been a mighty long time since i used it.
If you can rewrite the original code to use something better, sqlite would be good replacement for Access, but If a rewrite was in order, I'd choose PostgreSQL.
If you have to live with the legacy code, you might want to look at https://www.microsoft.com/en-us/download...x?id=13255 and implement into python.
This looks like just that: https://pypi.org/project/msaccessdb/
The same author that wrote above, also wrote an SQLAlchemy interface to MSAccess: https://pypi.org/project/sqlalchemy-access/
If you can rewrite the original code to use something better, sqlite would be good replacement for Access, but If a rewrite was in order, I'd choose PostgreSQL.
If you have to live with the legacy code, you might want to look at https://www.microsoft.com/en-us/download...x?id=13255 and implement into python.
This looks like just that: https://pypi.org/project/msaccessdb/
The same author that wrote above, also wrote an SQLAlchemy interface to MSAccess: https://pypi.org/project/sqlalchemy-access/