What kind of locktype needed?

[kruxty]

Sub InsereLogins(User)

Dim adoConInsereLogins
Dim strSQLInsereLogins
Dim rsInsereLogins
Dim Data
Dim Hora

Data = FormatDateTime(Date, 0)
Hora = FormatDateTime(Time, 4)

Set adoConInsereLogins = Server.CreateObject("ADODB.Connection")
adoConInsereLogins.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("dbs\users.mdb")
strSQLInsereLogins = "SELECT Logins.User, Logins.Data, Logins.Hora FROM Logins"

Set rsInsereLogins = Server.CreateObject("ADODB.Recordset")

rsInsereLogins.CursorType=2
rsInsereLogins.CursorType=3
rsInsereLogins.Open strSQLInsereLogins, adoConInsereLogins

rsInsereLogins.AddNew
rsInsereLogins.Fields("User") = User
rsInsereLogins.Fields("Data") = Data
rsInsereLogins.Fields("Hora") = Hora
rsInsereLogins.Update

rsInsereLogins.Close
set rsInsereLogins = Nothing
set adoConInsereLogins = Nothing

End Sub

It gives me this error:

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/Procura_Nome/testalogin.asp, line 61

This is line 61:

rsInsereLogins.AddNew

 

[kruxty]

I found the mistake, i had put two cursortypes!

Now says that "Database or object is read-only" in this line:

rsInsereLogins.Update

 

[Tarwn]

Here is a reference page for the Recordset object:

http://www.w3schools.com/ado/met_rs_open.asp

outlines what argumets you can give it for cursor and locktype as well as descriptions.

Though I feel like I should mention that opening a recordset just to add a new record is a bit wasteful, you should simply use a Connection object, the .Execute method, and an SQL INSERT statement.

-T