I have a strange problem with Access databases. When I try to add a new record, it adds it to to end of the database. That's OK. But after sometime it starts to add them to the beginning of the database. Can someone tell me how can I prevent it doing this? I need to add all the new records to the end of the database. Thanx for your answers.
It's code is like this :
dbPath = Server.MapPath("..\db\yyy.mdb"
set zzzz = server.createObject("ADODB.Connection"
set rs = server.createObject("ADODB.Recordset"
zzzz.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & dbPath)
'veritabani.Open ("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & dbPath)
rs.activeconnection=zzzz
rs.locktype = adlockoptimistic
sqlstring = "SELECT * FROM bbbb"
rs.open sqlstring
rs.movelast
rs.addnew
rs("xxx"="xxx"
rs.update
rs.close
zzzz.close
It's code is like this :
dbPath = Server.MapPath("..\db\yyy.mdb"
set zzzz = server.createObject("ADODB.Connection"
set rs = server.createObject("ADODB.Recordset"
zzzz.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & dbPath)
'veritabani.Open ("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & dbPath)
rs.activeconnection=zzzz
rs.locktype = adlockoptimistic
sqlstring = "SELECT * FROM bbbb"
rs.open sqlstring
rs.movelast
rs.addnew
rs("xxx"="xxx"
rs.update
rs.close
zzzz.close