The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

MySQL and Access

Hello,
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.