View original (French)

Cannot insert table via Access ODBC driver

mfer69 -  
Hello,

I'm having an issue with my website. It is configured locally via Wamp. I am unable to insert records into the MySQL tables via Access; when I try I get the error message "ODBC -- Insertion failure on the attached table <

3 answers

  1.  yg_be Contributor Ambassador
    Hello, how do you perform the insertion?
    0
    1. mfer69 Author
      Hello,
      I’m encountering the same problem, whereas a few years ago I used to do it regularly.
      I created an insert query that is supposed to update the MySQL database. But if I try to add a record manually, I get the same message.
      0
      1. yg_be Contributor Ambassador
        What same problem as what?
        have you tested with a simple table, containing only one field?
        0
    2. mfer69 Author
      The Access→MySQL connection problem via ODBC.
      On my site, there isn't a table with just a single field...
      The problem is that it worked a year ago and it doesn't want to work anymore.
      0