Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: re: This recordset is not updatable

    Hi all,

    I created a form that links to a view. The view joins the two tables and both of these tables are defined w/ Primary keys. But when I try to update the table is giving an error in Access form: "This recordset is not updatable".
    Would anyone have an explanation for this?
    I'm using AC2K and SQL Server 2K.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    You can only update columns in the view from one table with one update statement. You can only update columns if you have all of the columns in the declared PK for the table in the view.


Posting Permissions

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