Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Unanswered: ODBC linked tables & RECORDSET Method

    Hi folks,
    I have a problem with a MS Access 2003 database.
    There are ODBC linked tables in my database, there is no problem to use/update theses tables with a form or directly in the table.

    But I would like to add reccord in my tables with the recordset method .. .but it doesn't work .. I have the following error : "error 3146 ODBC--Call Failed" on the update command

    This is my code :

    set db = DBEngine.Workspaces(0).Databases(0)
    set rs = db.OpenRecordet("INVENTORY")

    rs.Addnew
    rs!comment="test test"
    rs!supplier="Mister mr"
    rs.Update
    rs.Close


    Could you please let me know what's wrong or witch procedure do I have to use to add reccord in this table?

    Thank you so much for your help!!!

    Nath,
    Kiss.

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    Try:


    set db = CurrentdB
    set rs = db.OpenRecordet("INVENTORY",dbOpenDynamic)

Posting Permissions

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