Dear All,

I have an assignment to change the back-end database of the MS Access 2003 application to MySQL.

I know nothing about MySQL and can someone share with me we should I start. Is there any friednly user interface to create a MySQL database/table instead of the Admin command. And also how to link and tranfer the existing data over.

Please help.

Thanks.

Search for MySQL control Center.

It's no longer in production but you should be able to find a copy from somewhere... if not then PM me and I'll try and e-mail it you.

Once you#ve created your DB then simply create an ODBC Connection to it and then export from your existing BE to it via the ODBC Connection... then link the MySQL tables (via ODBC) in your existing FE.

One thing you might also need to do is go into every table and add a timestamp field.

This links will help you
=> MySQL Control Center
=> Migrating from Microsoft Access to MySQL
Greetz from Belgium (IMG:http://www.utteraccess.com/forum/style_emoticons/default/compute.gif)

Luc aka Kuifjexx

Thanks for the links, they are very useful indeed.

Glad I could help you (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

Greetz from Belgium (IMG:http://www.utteraccess.com/forum/style_emoticons/default/compute.gif)

Luc aka Kuifjexx

Oh my goodness - the secret is out - Danny is the Stig !!!

FWIW, you could try out MySQL's Workbench as well. This provides a GUI for administering & designing MySQL databases.

It's just me but I personally prefer to build the tables then import the data into the new structure. This way I know that there won't be problems due to differing data types and whatnots.

You may find it interesting as well the links contained within helpful:

Beginner's Guide to ODBC

HTH.