Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2016
    Posts
    2

    Answered: Runtime 3073 with DoCmd.RunSQL

    I am using the following code and keep getting this runtime error:

    ssql = "update mytable set mycolumn = '11'"

    docmd.runsql ssql


    The error states that I must use an updatable query. I used the similar syntax to delete all rows from this table earlier in this routine with no problems.

    Help..

  2. Best Answer
    Posted by ranman256

    "Is myColumn a string? It will fail if it is numeric.
    Instead of SQL, Did you try it as a query? It can give better error messages."


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Is myColumn a string? It will fail if it is numeric.
    Instead of SQL, Did you try it as a query? It can give better error messages.

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
  •