connect access front end to mysql back end.
I have seen it done in the past but at the time my limited knowledge did not retain how to do it, it is connected through the odbc, im am running server 2000 what code do i use to connect and how do i set up the odbc

any help would be appreciated