Connection to MySQL is read-only. UGH! [RESOLVED!]

[Abraxus]

I'm having some DB bloat issues ( see http://www.eileenslounge.com/viewtopic.php?f=29&t=1185 ) and thought I'd try MySQL as a solution.

I got it all set up (yeah!!) but when I link to the MySQL table, it's read only (Boo!).

Did I do something wrong? Is there a way to fix it?

Thanks!

[HansV]

Have you set the correct permissions for the MySQL tables?

[Abraxus]

Permissions was my first thought, so I checked them all thoroughly...no luck.

Then I noticed that of the 10-15 tables I linked, I could modify some of them (just not the one I REALLY needed). Odd.

A little Google-ing found this : You must now select a unique field in your table. This is essential - if you do not do this, the table will be read-only within Access and you won't be able to make any changes.

I had not selected Key Fields, so it was read-only.

I relinked, selecting key Fields, and BINGO! It works!!

Now I can stop pulling out what little hair I have.

[HansV]

Great! The same holds for SQL Server, by the way.