An INSERT query is not returning recordset.
Replace "Set RS = conn.execute(SQLstmt)"
with "conn.execute(SQLstmt)"
>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com