Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    820
    Provided Answers: 5

    Unanswered: QODBC and Access

    I have An access Frontend to backend application which has no issues. Just recently I installed and tested with success the QODBC driver to link to the vendor table and PO tables. I can open the Vendor table in datasheet view and view and edit all records, I can even add records in datasheet view view

    However when I run code to (DAO or SQL execute) I get the following error


    Access: Run-time Error 3155 ODBC insert on a linked table failed

    I can't find anything specific for this

    any help would be greatly appreciated.
    Dale Houston, TX

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    629
    Provided Answers: 32
    It sounds like this ODBC driver is not 100% compatible.
    Can you revert back,or get a valid compatible driver?

  3. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    820
    Provided Answers: 5
    Driver is the latest supplied by QODBC

    I was able to add a record if I used a bound form that I created and then it would create a record - but not from code or a sql execute.
    Dale Houston, TX

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •