Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: This recordset is not updatable

    I received this error message:
    "This recordset is not updatable"

    I was trying to edit my fields in the subform in Access the recordsource is a table which resides on SQL Server. I checked the locked property of the control and form objects they are set to 'no' or false. The recordset type property of the form is Updatable Snapshot. So the problem must lies in table definition. How can I check if that is the problem? I'm new at MS SQL Server I would appreciate any help.

    Thank you.

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    YOu did not mention If you are using ODBC or an Access Project file.

    You can check one of two things.

    1. The user specified in the SQL Connection has read and write permissions.

    2. That the table you are trying to edit has a primary key.
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    May 2002
    Posts
    395

    The recordset is not updatable

    Originally posted by machado
    YOu did not mention If you are using ODBC or an Access Project file.

    You can check one of two things.

    1. The user specified in the SQL Connection has read and write permissions.

    2. That the table you are trying to edit has a primary key.
    Hi,

    Thanks for your reply.
    I'm using an Access Project file. I checked the table, it has an id field and the identity column is checked and value is incredment by one. Why couldn't you edit fields of a table with a primary key? How do I check for permissions in The SQL Connection? Would it be in the code?

    Your help is greatly appreciated.

  4. #4
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    To check the connection

    click on File, Connection

    You need a primary key for Sql to be able to write to a record. And I can assure you that this would be the problem and not the Connection.

    Add a primary key say rec_id as uniqueidentifier data type and IsRowGUID checked and set as a primary key.

    This will sort out the problem.
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  5. #5
    Join Date
    May 2002
    Posts
    395

    recordset is not updatable

    To check the connection

    click on File, Connection

    You need a primary key for Sql to be able to write to a record. And I can assure you that this would be the problem and not the Connection.

    Add a primary key say rec_id as uniqueidentifier data type and IsRowGUID checked and set as a primary key.

    This will sort out the problem. [/SIZE][/QUOTE]



    [QUOTE][SIZE=1]Originally posted by machado
    THANK YOU! THANK YOU!
    YES! That's the problem. I'm missing the primary key field in the table.
    Thanks for your help.
    Have a great day!

Posting Permissions

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