Locked Table

I have just moved our access database to MySQL and are still using access as a front end using ODBC and link tables.

There are around 50 tables in the database but for some reason one of them is un-editable.

If I click on the link table then it shows the datasheet view of the table but I cannot change any data. I can't see any settings different to the other tables which are working fine.

Any ideas?


I am also having the problem with #Deleted occasionally appearing in all fields when adding data through an access form to another table. This works fine a lot of the time but the problem seems to be really random.

Any help in this area would also be greatly appreciated!

Thanks

Just in case anyone has the same problem. The answer was that when transferring the data from access to mysql it hadn't saved the primary key information and this was the only table without one. Defining it's primary key solved it.