Access 97 application migration from MSSQL to MySQL backend

Hi forum

As a part of a migration project I am trying to migrate an Access 97 application from a MSSQL backend to a MySQL one.

I have used the migration tool transfer the tables and have afterwards made sure every table contain an autoincremented  primary key (INT) and a dummy TIMESTAMP field, which is updated upon update of the row.

I am using MyODBC 3.51.12 with ”Return matching rows”, ”Allow big results”, ”Don't optimize column width” and ”Change BIGINT columns to INT” enabled.

Everything is working except newly created rows by the Access application, which show up as #DELETED, even though they are created in the MySQL db.

If I restart the application, they show as they should.

Any suggestions on how to solve this without touching the Access code?

Thanks in advance,

Torkil