This is the error that I get:
[Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query.
It worked previously before I installed Jet 4.0 SP 8 b/c
Access 2003 requested it. Database is in Access 2002
format.
This is what I'm doing.
---------------------------------
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="
& g_DatabasePath & "; Data
Provider=Microsoft.Jet.OLEDB.4.0"
Set RSw=Server.CreateObject("ADODB.RecordSet")
RSw.CursorLocation = 3
RSw.LockType = 3
sQuery="Select * from People;"
RSw.Open sQuery, Conn
RSw.AddNew
RSw("Name")=sName
RSw.Update
RSw.Close
Conn.Close
--------- and in another instance just by replacing the
last 5 lines with the following:
RSw("Name")=sName
RSw.Update
RSw.Close
Conn.Close