Hi,
I have had to do what you are trying to do in the past.
Lessons learnt:
1) Do not keep Access as the front end and MYSQL as the backend.
The MYSQL ODBC driver is bug prone and not fit for purpose.
My recommendation would be:
1) Use one of the many simple tools available that import an .MDB file
directly into MYSQL.
2) Re-write the equivalent of the Access front end as web pages or web services.
(2) is sometimes a lot of work, but the final solution is far more
maintainable and manageable.
Kind regards
James
--
Please post to: Hampshire@???
Web Interface:
https://mailman.lug.org.uk/mailman/listinfo/hampshire
LUG URL:
http://www.hantslug.org.uk
--------------------------------------------------------------
