Program read but dont delete registers? mySQL error?

[jotacasashout]

I'm trying to make an Access file communicate with my mySQL server. It happens that when i link the spreadsheet data with the mySQL server, the program no longer recognizes the Access file and gives the following error:




Unable to delete items from the specified tables

SQL: DELETE FROM Config WHERE

The program crashes and closes, is there a way to fix this or is there another way to link my access database?

[Gicu]

Do your have primary keys specified for all your tables? Usually this is the main cause of not being able to edit linked ODBC tables in Access. But could also be permissions set in the MySQL server that don't allow the deletion.

Cheers,