I used to program MS Access. The ODBC driver does not let you
put MS Access on UNIX. What it does it allow MS Access to talk
to a regular UNIX database. So you run MS Access on your
desktop machine and it talkes to the UNIX database on the UNIX
The MS Access database is then referred to as the "front end"
and the UNIX database is the "back end". You, in effect, use
MS Access and do not have to be aware of the UNIX database
on the UNIX machine.
The ODBC stuff would be supplied by the UNIX database, not
the MS Access database.
Bunch of linux desktop apps use that library and it alway provides "read only" access so I do not think there is much benefit to it other then parsing mdb file and dumping data in mysql or postgres database.
If I am in the same situation as you are, I would be fair to my client and tell them that they will not be able to fully utilize Access database on linux and they should look for windows hosting.