I've spent 3 hours+, and....Access ODBC piss me off!
Please, somebody have any clue to fix it?
set conn = Server.Createobject("ADODB.Connection")
conn.open "lista1"
SQLstmt = "INSERT INTO lista (Name,City,State,Country,Email,Usuario,Password)"
SQLstmt = SQLstmt & " VALUES ("
SQLstmt = SQLstmt & "'" & Name & "',"
SQLstmt = SQLstmt & "'" & City & "',"
SQLstmt = SQLstmt & "'" & State & "',"
SQLstmt = SQLstmt & "'" & Country & "',"
SQLstmt = SQLstmt & "'" & Email & "',"
SQLstmt = SQLstmt & "'" & Usuario & "',"
SQLstmt = SQLstmt & "'" & Password & "'"
SQLstmt = SQLstmt & ")"
Set RS = conn.execute(SQLstmt)
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.