We had a number of bugs for usage of Microsoft Access Database: 
Bug 107360, Bug 114794, Bug 97395, Bug 97579, Bug 107890.

Thanks to Alex, some of them were closed with the following explanation:

Microsoft no longer provides for reading/writing to a 32bit Access db (versions created with Access 97, 2003) on its 64bit systems. There is information about this on both MSND, and Microsoft's own knowledgebase websites.
On a 64bit OS with 64bit programs, MS no longer supports 32bit access to Access MDB files made on a 32bit system (see MS' own support forums and the MSDN forums). 
As LO relies on Microsofts own drivers to do this, Access97 and Access2003 files are no longer accessible with 64bit LO. If there is no MS support, there is not much we can do.
All-64bit setup works :
- 64bit OS
- 64bit accdb Access >= 2010
- 64bit Access Database Engine (2016) - database drivers provided by MS

There was some workaround mentioned, I didn't test:
There is a way to do this in 64-bit if you use a JDBC connector - UCanAccess: https://ask.libreoffice.org/en/question/145877/mdb-files-not-loading-to-base/
May exist a problem of passing the required parameter into the database in order to create the report. Create a single record table containing that parameter, and connect that into the database.

We still have Bug 43187.

I didn't find a proper documentation, just https://help.libreoffice.org/6.2/en-US/text/shared/explorer/database/dabawiz02access.html 
I suggest it be created. We may rely on wiki page https://wiki.documentfoundation.org/MSA-Base_Faq 

Now it just points to https://wiki.openoffice.org/wiki/MSA-Base_Faq which I find wrong. We should explain all what we can here, using and updating info that one and https://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access.