>-----Original Message-----
>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
>
>.