Ho seguito la guida presente quì per aggiornare un record database access.
Ci sono 3 pagine:

modifica1.asp
modifica2.asp
modifica3.asp

quando da modifica1.asp richiamo modifica2.asp
richiamando un qualsiasi id di record,
modifica2.asp mi mostra sempre il primo id in lista al database.

Non ci dò fuori.


modifica1.asp:

<%
dim strCode
strCode="innovatel"
dim intVolta
intVolta="0"

myDB = "../mdb-database/prova.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(myDB)

strConn=strConn & ";pwd=" & strCode

sql = "SELECT * FROM prova"

Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "prova", conn, 3, 3

do while not(rs.eof)

%>


<td ><%=rs(1)%></td>
<td ><%=rs(2)%></td>
<td ><%=rs(3)%></td>
<td ><%=rs(4)%></td>
<td ><%=rs(5)%></td>

<td >modifica</td>




modifica2.asp:

<%
dim strCode
strCode="innovatel"
dim intVolta
intVolta="0"

myDB = "../mdb-database/prova.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(myDB)

strConn=strConn & ";pwd=" & strCode

sql = "SELECT * FROM prova"

Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "prova", conn, 3, 3
%>



<form method="post" action="modifica3.asp?Id=<%=rs(0)%>">
<table>
<tr><td>1</td>
<td><input type="text" name="1" value="<%=rs(1)%>" /></td></tr>

<tr><td>2</td>
<td><input type="text" name="2" value="<%=rs(2)%>" /></td></tr>

<tr><td>3</td>
<td><input type="text" NAME="3" value="<%=rs(3)%>" /></td></tr>

<tr><td>4</td>
<td><input type="text" NAME="4" value="<%=rs(4)%>" /></td></tr>

<tr><td>5</td>
<td><input type="text" NAME="5" value="<%=rs(5)%>" /></td></tr>

<tr><td><input type="submit" value="Modifica" /></td><td>
</td></tr>
</table>
</form>