Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2015
    Posts
    3

    Unanswered: 3113 error, field not updateable

    Got a 3113 error, no clue what that means. Here is my code

    Private Sub Command51_Click()
    Dim strSQL As String
    strSQL = "UPDATE dbo_customer " & _
    " SET dbo_customer.invoiced = '1'" & _
    " WHERE dbo_customer.[customer_mail_adress] = '" & Me.txtMail & "';"
    DoCmd.RunSQL strSQL
    End Sub

    Error says: "cannot update "invoiced", field not updateable.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    1. In the name dbo_customer the prefix dbo_ indicates that the target is a table on a SQL Server or a view attached as a table. Is this table (or view) updatable in the Access database?

    2. How is the column invoiced defined on the server? Is it a computed column or, for any reason (several are possible), a read-only column?
    Have a nice day!

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

    ...In the name dbo_customer the prefix dbo_ indicates that the target is a table on a SQL Server or a view attached as a table...
    Because this is Sinndho posting, I assume that we are, in fact, dealing with a Table in SQL Server, and so have to ask if your Table in SQL Server has a Primary Key, or at least a Unique Index, defined for it? Also, is the PK part of the RecordSource of the Form? If not it will be Read-Only using ODBC.

    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

Tags for this 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
  •