Results 1 to 2 of 2

Thread: ODBC Update Failed Error 3157

  1. Dec 15th, 1999, 02:01 AM #1
    JadedLadyHawk
    JadedLadyHawk is offline

    Thread Starter
    New Member
    Join Date
    Oct 1999
    Posts
    2

    Post

    I am editing data. I open up the recordset to "edit" then have a line to Update. I get an error when trying to update. Please help.
    Reply With Quote Reply With Quote
  2. Dec 15th, 1999, 03:29 AM #2
    Aaron Young
    Aaron Young is offline
    Guru Aaron Young's Avatar
    Join Date
    Jun 1999
    Location
    Red Wing, MN, USA
    Posts
    2,177

    Post

    When you created the Recordset, did you create an Updatable one?, ie with OpenKeySet?

    If you open a Forward only or Static Recordset you're going to get Errors when trying to perform Edits/Updates.

    If not, check the ODBC Properties to make sure you enabled Write Access.

    ------------------
    Aaron Young
    Analyst Programmer
    [email protected]
    [email protected]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width