ASP / HTML Links

[Raven_Writer]

Is there a way to determine if a user clicks on a link, and if so, update a file / database?

Also, this is more geared to ASP: If you already have an SQL query executed, how can you do another?

Example:

PHP Code:

<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("directory\to\database\file.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM files"
Set RS = MyConn.Execute(SQL_query)
%> 


How would I be able to run another SQL query (like UPDATE)?