Re: converting access db to mysql

You can certainly move the data to mysql, and keep the ms-access front end.

A large portion, in fact most of the forms and reports will work. However, do you need to be aware of some differences etc.

And, most code as is will also work.

The main areas to watch are:

    You need to have both a primary key, and a timestamp in EACH table on the mysql side.

    You can continue to use the ms-access query builder. For reports, queries that have multi-table joins should be changed to pass-through, and that performances VERY well with mysql.

So, this project is do-able. However, you should have a good familiarly with ms-access, and your initial problems with ms-access need to be solved first.

good luck!

-- 
Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal_at_msn.com
http://www.attcanada.net/~kallal.msn