Operation must use an updateable query

[Frustrated]

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

 

[Ray at]

Go to www.aspfaq.com and enter this search phrase:
How do I solve 'Operation must use an updateable query' errors?

Also, change from ODBC to OLEDB by mimicking the OLEDB connection string for
Access found here. www.connectionstrings.com

Ray at work

 

[Aaron Bertrand - MVP]

[Microsoft][ODBC Microsoft Access Driver] Operation must

use an updateable query.
http://www.aspfaq.com/2062


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")

ugh, what is this for?
http://www.aspfaq.com/2191

sQuery="Select * from People;"
RSw.Open sQuery, Conn

RSw.AddNew

Why are you doing this? Use an INSERT statement.

 

[Frustrated]

Thanks that worked!

Problem was Internet Guest Account didn't have enought
permissions. Why this worked before SP8 I have no idea.

-----Original Message-----
Go to www.aspfaq.com and enter this search phrase:
How do I solve 'Operation must use an updateable query' errors?

Also, change from ODBC to OLEDB by mimicking the OLEDB connection string for
Access found here. www.connectionstrings.com

Ray at work

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.

.