Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2014
    Posts
    18

    Unanswered: "This recordset is not updateable"

    Hi all! I am having the error message "This recordset is not updateable" when trying to edit information in my form. I suspect it has something to do with my Record Source...? I have attached the DB here. ANY help would be GREATLY appreciated.

    ~AccessNewb~
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    The recodset is missing the primary key of one or more tables so the SQL engine cannot uniquely identify what row to update.
    IIRC some queries are not capable if being updated
    usually that requires a redesign of the firm with sub/child tables as sub forms embedded in the oarent form
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by healdem View Post

    ...IIRC some queries are not capable if being updated...
    That's correct; Allen Browne explains the why and wherefore, here:

    Microsoft Access tips: Why is my query read-only?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Apr 2014
    Posts
    18
    Great, thank you guys!!!
    ~AccessNewb~

Posting Permissions

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