ODBC is middleware. LO conects to it, other vendors would be responsible for making sure their own software connects to it too. Lack of interoperability is a reason I stopped using Access (and switched to MySQL/MariaDB backend, not LO HSQLDB).
If you are porting from Access permanently, I would suggest outputting the database into another format, for example csv or dBase files, and then importing into LO for native use, or some other backend on Mac that does have ODBC or JDBC drivers. Instructions for importing data into LO base from spreadsheets is available here.