Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    7

    Unanswered: recordset not updatable

    Hi
    I have a from binding to a query which always fetches only one record that matches the criteria, when i try to edit this form, it says recordset not updatable.. what does this mean and what could be wrong with my query??? My query has 2 tables and 2 joins on the year and Id

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    chances are the id from the primary table is the id in the query. drop the id from the secondary table (no primary key on id) into the query and see what happens

    also if you are specifying unique records, you cannot update or delete the record.

Posting Permissions

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