Help linking Access to MySql

I have a client that needs to link his PC running Win 2000 and Access to an online MySql database. Everything appeared fine until the following errors started happening when he began to add/edit records. "I can't edit/delete existing records, I get this error: "ODBC --call failed [TCX][MyODBC] Transactions are not enable #0"" "I type something in a new record for the quotes table, leave that row and the entire row turns to #deleted. Exit the table and reload it and the entry is there." When asked about his settings he said: I have the latest versions of MDAC. Microsoft Jet 4.0 was part of a recent win2k service pack. I've also check "flag Return matching rows" and "Simulate ODBC 1.0". Please help US!! ## Deliverables Help. ## Platform Mentioned above.