I'm using ODBC to link the tables in mySQL to Access. What is the right procedure in creating this database?
Should I create all the tables in mySQL and then link it via ODBC to Access and then starting building the database or can I create the database with Access and export it to mySQL? I tried doing the latter but things like "primary key" info did not transfer to mySQL. For example, in the Access, i set "ID" to be my primary key. I exported this table to MySQL and then I commanded to "describe" the table - it did not have "PRI" next to the "ID"...
At first bounce, I'd say the first method is your best bet. Access, up to version 2000 was never very good at "upsizing" and even then, it was only any good at going to SQL Server. No surprise there.
Access does function remarkably well as a front end for server databases. It has a decent reporting engine and if you don't mind getting your hands dirty with VB, a pretty good small/medium scale programming environment.