committrans or rollbacktrans from access

[Alain Terranova]

Hello,

I would like to process a simple tansaction... something like the following code:

Dim conn As ADODB.Connection
Dim rst As ADODB.Recordset

Set conn = New ADODB.Connection
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & mysqlSERVER & _
"DB=DB_MAIN_TEST;" & _
mysqlUID & mysqlPASSWORD & mysqlOPTIONS
conn.Open
conn.BeginTrans

conn.Execute "INSERT INTO tbl_phone_nbrs (phone_nbr) VALUES (""043585587"")"

conn.RollbackTrans
conn.Close
Set conn = Nothing


But when a execute the "RollbackTrans" command, I received this error:
"Som non-transctionnal changed talbes couldn't be rolled back"...

What's wrong?