#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Germany
    Posts
    3
    Rep Power
    0
    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

  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Posts
    1
    Rep Power
    0
    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...
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Germany
    Posts
    3
    Rep Power
    0
    hey very cool!!! it runs and runs

    thank you very much

Similar Threads

  1. Need advice designing a usage tracking database (MySQL)
    By Randolpho in forum Database Management
    Replies: 0
    Last Post: February 13th, 2004, 04:11 PM
  2. From Access to remote MySQL
    By TimMatthews in forum Database Management
    Replies: 0
    Last Post: February 3rd, 2004, 09:54 AM
  3. Accessing a Mysql Database on a different host.
    By tekgen in forum MySQL Help
    Replies: 2
    Last Post: February 1st, 2004, 06:54 PM
  4. Replies: 0
    Last Post: January 30th, 2004, 08:46 PM
  5. database type: mySQL, MS SQL and Access
    By vinyl in forum ColdFusion Development
    Replies: 5
    Last Post: January 27th, 2004, 07:25 PM

IMN logo majestic logo threadwatch logo seochat tools logo