ok, i`m new in asp.i`ve made access database end i`ve 'tried' to make a code:
   __________________________________________________ ____
<%
baza="Data Source=" & Server.Mappath("db1.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open baza
set rs=Conn.execute("select * from Tabela")
if not rs.eof then
response.write ("<table border='1' align='center' cellspacing='0' cellpadding='0' bgcolor='#CCCCCC'>")
do while not rs.eof
Response.write("<tr><td><form><input type='text' name='user' id='user' value="&rs("Username")&"></form></td><td><a href='baza.asp?edit="&rs("id")&"'>UPDATE</a></td><td><a href='#'>DELETE</a></td></tr>")
rs.movenext
loop
end if
if request.querystring("edit")<>"" then
Conn.execute("Update Tabela set Username='"&request.form("user")&"' where id="&request.querystring("edit")&"")

end if
%>
      __________________________________________________ ________
and when i try to update an new value over the existing one in my database, i`m giving this result:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/baza.asp, line 21



HELP!!!

You need to verify that you have valid values for both of your request variables that are used in your update -

Do a response.write of the update statement to see if it is valid. I notice that you are using both the form and the querystring to get values - which perhaps is okay, but not commonly done and might be the cause of your problem.

Comment out the "Conn.Execute" line and replace it with the following two lines. This will display your sql so you can verify it is correct:
Woody Z
http://www.learntoprogramnow.com