Recent content by karent

  1. K

    ODBC--Insert table failed

    Well the problem ended up being 1 field in a table of 78 fields that had a default value set to 'none' and when switched to 'null' it now works. Mysql 5.7 doesn't like "none' apparently where it didn't bother 5.6
  2. K

    ODBC--Insert table failed

    Thank you for your suggestion but I am so not an IT person and truly don't understand it.
  3. K

    ODBC--Insert table failed

    I can insert a record directly into the table in sql but not in access. The field types do not appear to have changed.
  4. K

    ODBC--Insert table failed

    I did try Minty's suggestion and there was no change. I tried an insert directly into the sql table and it worked. So there is something with the ODBC connection to Mysql.
  5. K

    ODBC--Insert table failed

    Structure / constraints have not changed in 5 years. I am sadly the DBA. Only change is mysql update.
  6. K

    ODBC--Insert table failed

    Yes I have deleted the link and relinked. Sadly no difference.
  7. K

    ODBC--Insert table failed

    I am using Access 2010 with ODBC (5.3) connection to Mysql database. I recently updated from Mysql 5.6 to 5.7. The tables are linked. There is one table that will not allow inserts. Edits work. Other tables allow inserts. Just one table gives me the above error message. There is a...
Top Bottom