Connect to MySQL across network using MS Access

comment out line in /etc/mysql/my.cnf that reads:

 bind-address = 127.0.0.1

• grant root access across network (see MySQL Documentation)

 mysql> use mysql;
 mysql> select Host, User, Password from user;
 mysql> update user set host='%' where user = 'root';
 mysql> q

• restart

 $ /etc/init.d/mysql restart

• install/configure odbc on server

 $ aptitude install libmyodbc

• configure Access on client
  • download/install MyODBC
  • create a new database (not a project)
  • File, Get External Data, Link Tables, ODBC Databases
  • Create a MyODBC DSN