Updating Access Databases

Results 1 to 2 of 2

Thread: Updating Access Databases

  1. #1
    Join Date
    Dec 1969

    Default Updating Access Databases

    I am trying to update an access database but can not figure out how. I can only get it to add new records. How do I change data in an old record.

  2. #2
    Join Date
    Dec 1969

    Default RE: Updating Access Databases

    just use rs.update at the end :<BR><BR> rs.open SQLStmt,conn,2,3<BR> RS("whatever")=session("userid")<BR> RS("dateapproved")=tempdate<BR> RS.Update<BR> RS.Close

Posting Permissions

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