View original (French)

Cannot insert table via Access ODBC driver

mfer69 Posted messages 9 Status Member -  
mfer69 Posted messages 9 Status Member -
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 Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassadeur 1 588
     
    Hello, how do you perform the insertion?
    0
  2. mfer69 Posted messages 9 Status Member
     
    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 Posted messages 23437 Registration date   Status Contributor Last intervention   1 588
       
      What same problem as what?
      have you tested with a simple table, containing only one field?
      0
  3. mfer69 Posted messages 9 Status Member
     
    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