Im about to put the final touches on my access project - which means migrating it to work with mysql on a linux server.
Now Ive heard that mysql has some problems with ADO, is this a fact? I deliberatly used only ADO and abandoned DAO for the migration to work.
And - as I forsee this is gonna be hell to go through, does anyone have any tips for me (about the migration)?
I don't know what Access version or Linux you're running, but I have some experience in such situation. I've got a recent mySQL on Debian Linux and Access 2000 (with ADO 2.6) on Windows 2000 machine. At least for me ADO has been working fine with VBA code. Just ensure to get the mySQL drivers for Windows properly installed & configured. I've done thousands of INSERTs and big SELECTs (automated, mostly testing purposes) and I've noticed no problems with ADO.