469,625 Members | 1,094 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

Operation must use an updateable query

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

Jul 19 '05 #1
3 13868
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

"Frustrated" <ic*******@hotmail.com> wrote in message
news:05****************************@phx.gbl...
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.

Jul 19 '05 #2
> [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.
Jul 19 '05 #3
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 forAccess found here. www.connectionstrings.com

Ray at work

"Frustrated" <ic*******@hotmail.com> wrote in message
news:05****************************@phx.gbl...
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.

.

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by ano1optimist | last post: by
8 posts views Thread by Jim in Arizona | last post: by
11 posts views Thread by Arpan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.