Search results

  1. M

    Run Time 3703 - Operation must use an updateable query

    In fact the first response answers the problem, I have GROUP BY in one my sub queries, rendering the action query read only. Thanks RuralGuy. I assume creating a temporary table (based on the result of the above SQL) to update the SQL server table would be a work around... UPDATE...
  2. M

    Run Time 3703 - Operation must use an updateable query

    Quite right you are. Not particularly readable, will redo it. Thanks
  3. M

    Run Time 3703 - Operation must use an updateable query

    Hi all, I am trying to update to a SQL table via Access form using ODBC connection. The form has a selection of unbound fields that once populated I wish to be updated to relevant fields in SQL table. I have written the attaced code attached to a button at the bottom of the form. i was...
Back
Top Bottom