ODBC: How
to set up MS Access 97 to access your mySQL database
Open MS Access and create a new database.
From the file menu, choose
File and then Get External Data and then Link Tables. See
figure below:
From "Link" window
that comes up, choose ODBC Databases()
From the "Select Data Source" Window,
choose the DSN name you've setup for your online mySQL database. If
you haven't already
done so, see instructions here. Click
the OK button
.
From the "Link Tables" window
(image below), select the table you want to attach
and click the OK button.
ODBC could prompt you for the
primary key column in tha table, if it can't find it. Specify
one and that's it! The online mySQL
table is now attached to your local access database:
You may open the table, update,
inset or delete records. To attach all database
tables, follow the above steps for each table in your
database.