MS Access Transactions Not Working With MySQL -

MS Access Transactions Not Working With MySQL -

i'm have problem transactions, in ms access 2007 using odbc source mysql 5.6 database. essentially, i'm inserting 'master' record, , inserting 'child' records in table. however, records committed when explicitly roll them back.

a simplified version of function follows:

dim ws workspace: set ws = dbengine.workspaces(0) dim db database: set db = currentdb dim newid& ws.begintrans ' insert "master" record s = "insert ..." db.execute s ' new record id using passthrough query mysql newid = gfmysql_getnewid ' insert multiple "child" records, using newid s = "insert ..." db.execute s if vbyes = msgbox("commit?", vbquestion + vbyesno) ws.committrans else ws.rollback goto exit_handler end if

this has me stumped, if has suggestion appreciate it!

mysql transactions ms-access-2007