August 22nd, 2000, 01:54 AM
I'm trying to connect to the mySQL Database with MS-Access 2000. My OS is Win98. Everything works fine...
My Problem: I can't write into the tables of the MySQL Database from MS-Access. "The Database is writeprotected" is the Status Message.
Please Help... MS-Access is a very cool Frontend Tool and MySQL the best Backend Tool. IT MUST WORK!!!
greetings from germany
August 22nd, 2000, 06:58 AM
Check the permissions in the mysql tables. The user that is defined in the myodbc setup needs to have write privileges.
Check on devshed (there is an excellent explanation of the mysql grant tables).
Once you set the grant tables, don't forget to flush them so they get updated. After that, you should be able to write with no problem. (works like a dream here)
Greetings from Holland...
September 21st, 2000, 04:04 PM
hey very cool!!! it runs and runs
thank you very much