Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009

    Unanswered: Update Record in Sql server from Ms access 2010 adp

    Hello! i have a form which show record date, i want to be able to modify the data from the form and then save the changes back into SQL... Any ideas how?? ive tried setting it up as a passthrough server and all over google! any help would be GREATLY APPRECIATED

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    If the form is bound to the source table, this will happen on its own. If the form is unbound, you will need to write code (and work out how to trigger it) that creates a SQL script to carry out the update, and then send it to the database for execution.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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