Can write, can't delete. Help!

[bbbaldie]

I am running MySQL 3.23.51 for NT on a Dell 2550 Win2k server SP3. I have created a database there to which I link via Access 2002 on my desktop PC. I have a small table in Access that gets updated regularly. I then run a delete query to clear the linked MySQL table, then an append query to repopulate it with the updated info from the Access table. I then have a PHP page that displays the table's info.

The whole system worked flawlessly for two weeks. Then I began getting periodic errors saying that a query couldn't run. I would manually run the delete query and find that it worked fine. Eventually, it stopped running manually. I undid my linked table and relinked it. It came up read-only. I subsequently dropped the database from MySQL and rebuilt it. It still comes up read-only. It gets stranger.

While I can't DELETE anything from the table via Access, I can APPEND new data to the table! I have tried running the Access queries from other machines, I get the same error. I administer the web server, and have System full control privileges and everyone read and execute on the MySQL folder. I have tried bumping permissions up to Everyone delete, no help.

The MySQL user has full privileges to the database, including Grant option.

Anyone have any ideas?

 

[bbbaldie]

Solved it meself! The MySQL table had to have a primary key designated. Once I named a primary key, I could delete from it again via linking to Access.