In the last months, I develloped an small application with MySQL server and Access 97. It was my first experience with ODBC and I did some mistakes. (I must say at this point that my day job is in Access 97 and I know Access pretty well. I also work with MySQL server (for a database on a web server) and I know it well too.)
1. it's pretty easy to access your tables by ODBC with `link tables'.
2. your tables in MySQL server *must* have simple primary keys or it will be a mess in Access. (You can redefine the keys in Access, but I wouldn't recommand that.)
3. Don't use the SQL front end in Access. Use VBA code instead. You'll have more control over your recordsets.
Slashdot Mirror
I know, it's a little bit late but...
In the last months, I develloped an small application with MySQL server and Access 97. It was my first experience with ODBC and I did some mistakes. (I must say at this point that my day job is in Access 97 and I know Access pretty well. I also work with MySQL server (for a database on a web server) and I know it well too.)
1. it's pretty easy to access your tables by ODBC with `link tables'.
2. your tables in MySQL server *must* have simple primary keys or it will be a mess in Access. (You can redefine the keys in Access, but I wouldn't recommand that.)
3. Don't use the SQL front end in Access. Use VBA code instead. You'll have more control over your recordsets.
That's it.