It should work just fine.
Try loading some data from MySql with Excel..and see if that works (Excel is
great at this kind of stuff).
You of course do need to follow general practices like making sure each
table had a primary key, and also exposes a timestamp field.
So, you need to get your odbc setup correct. Any program from Excel, to
word, or ms-access can thus use that odbc connection.
Can you now view and see tables using the tools that come with Mysql? In
other words, you are wasting your time trying to get ms-access to work if
you can't connect, view, and browse tables using the tools that come with
the server product?
If you are having trouble with the basic tools to work with the tables, then
you might want to ask some questions in a group for mysql.
Once you get your connection, and table stuff working..then ms-access should
work. ms-access works fine with sql-server, Oracle, or most databases that
support odbc.
You are aware that a free sql-compatible engine is included on the office
cd? (in fact, you can even use the sql enterprise tools for free from
Microsoft to work with this 100% compatible sql-server engine. Even
triggers, and t-sql works with this engine).
Anyway..the answer is yes...it should work, so get your basic connection
setup first, and get the basic client tools that come with the product
working.
