Hanna's suggestion - is a good one. I have seen this error occur simply because the user credentials have been left blank when configuring the ODBC data source in Qlik Sense.
However, just in case:
Using ODBC does require the creation of the DSN using the ODBC administrator. However on some windows system, there are usually 2 ODBC Administrator tools. 1 for 32 bit and one for 64-bit. If you are not sure if you have the 64 bt MS Access driver - find the ODBC Admin tool - right-click on the program shortcut an take note of the path to where the .exe file is if you see wow64 - then that is the 32 bit ODBC admin. If you see that it is just in the System32 - then it is the 64 bit version.
Depending on which one you have - you need to configure the appropriate driver DSN in the appropriate tool.
Too make sure - you can download the Access Database Engine for 64bit and 32bit here: Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center
This will ensure you have the appropriate drivers which you can then configure.
Let us know how you do.