Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Would like to know how to update an

Status
Not open for further replies.

sugermama

Technical User
Oct 19, 2001
11
US
Would like to know how to update an Access record with a test score based on the user id and password of the test taker.

Thank you
 
'open conn here..

StrSql = "UPDATE table_name SET userscore = value
WHERE user_id=Idnumber AND password='mypassword'"

Set rs = my_conn.execute(StrSql) 'excute it here..

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top