In my link some posts ago, there is a solution from easysoft.
The basics are, test the odbc with a native testprogramm, if it works you can do it in lazarus. And if i want to write a multiplattformapp, i have to check the basics first.
Btw. With access there were also a lot of trouble with win64 native apps, if the driver are not correct too.