Updating table in Access asp

Results 1 to 2 of 2

Thread: Updating table in Access asp

  1. #1
    mark n Guest

    Default Updating table in Access asp

    Does anyone have any of their own sample code in updating a record in Access database using ID as a ways to grab a record and then update it. I have tried almost every technique. thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    168

    Default RE: Updating table in Access asp

    Here is an example from a simple contacts database, where I am updating FirstName, MiddleName, LastName, Title, IndivEmailAddr based on there CompanyID and ContactsID. Hope this helps!<BR><BR>&#060;%<BR>SQLupdate= "UPDATE Contacts SET Contacts.FirstName = &#039" & First & "&#039, Contacts.MiddleName = &#039" & MI & "&#039, Contacts.LastName = &#039" & Last & "&#039, Contacts.Title = &#039" & Title & "&#039, Contacts.IndivEmailAddr = &#039" & Email & "&#039 WHERE (((Contacts.ContactsID)=" & ContactID & ") AND ((Contacts.CompanyID)=" & id & "));"<BR><BR>cnn.Execute SQLupdate<BR>&#037;&#062;

Posting Permissions

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