By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,650 Members | 1,785 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,650 IT Pros & Developers. It's quick & easy.

must use updateable query

P: n/a
I'm getting this error on my web page:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/searchweb33.asp, line 5014

Here is the code producing it:

myDSN="d:\data\main_database.mdb
set conntemp3=server.createobject("adodb.connection")
conntemp3.Mode = 3 '3 = adModeReadWrite
conntemp3.open myDSN
sqltemp="update [db_version_table] set db_title='used'"
set rstemp3=conntemp3.execute(sqltemp)

The error is produced on the execute statement

What am I missing here? This code used to work fine on another server.

It says use an updateable query, and my query is updatable.

Any help would be appreciated.
Nov 24 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Web Search Store" <in**@websearchstore.com> wrote in
news:uH**************@TK2MSFTNGP15.phx.gbl:
I'm getting this error on my web page:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable query.
/searchweb33.asp, line 5014

Here is the code producing it:

myDSN="d:\data\main_database.mdb
set conntemp3=server.createobject("adodb.connection")
conntemp3.Mode = 3 '3 = adModeReadWrite
conntemp3.open myDSN
sqltemp="update [db_version_table] set db_title='used'"
set rstemp3=conntemp3.execute(sqltemp)

The error is produced on the execute statement

What am I missing here? This code used to work fine on another
server.

It says use an updateable query, and my query is updatable.

This is a common question. Search the asp.net groups on
http://groups.google.com/ for "updateable query".

Chris.
-------------
C.R. Timmons Consulting, Inc.
http://www.crtimmonsinc.com/
Nov 24 '05 #2

P: n/a
Make sure the ASPNET account (or the impersonated user) has modify
privileges on the directory where the .mdb file is stored. Access needs to
create a locking file as it works.

"Web Search Store" <in**@websearchstore.com> wrote in message
news:uH**************@TK2MSFTNGP15.phx.gbl...
I'm getting this error on my web page:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/searchweb33.asp, line 5014

Here is the code producing it:

myDSN="d:\data\main_database.mdb
set conntemp3=server.createobject("adodb.connection")
conntemp3.Mode = 3 '3 = adModeReadWrite
conntemp3.open myDSN
sqltemp="update [db_version_table] set db_title='used'"
set rstemp3=conntemp3.execute(sqltemp)

The error is produced on the execute statement

What am I missing here? This code used to work fine on another server.

It says use an updateable query, and my query is updatable.

Any help would be appreciated.

Nov 24 '05 #3

P: n/a
I blogged how to solve your problem at:-
http://spaces.msn.com/members/naijacoder
Hope that helps
Patrick

"Web Search Store" <in**@websearchstore.com> wrote in message
news:uH**************@TK2MSFTNGP15.phx.gbl...
I'm getting this error on my web page:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/searchweb33.asp, line 5014

Here is the code producing it:

myDSN="d:\data\main_database.mdb
set conntemp3=server.createobject("adodb.connection")
conntemp3.Mode = 3 '3 = adModeReadWrite
conntemp3.open myDSN
sqltemp="update [db_version_table] set db_title='used'"
set rstemp3=conntemp3.execute(sqltemp)

The error is produced on the execute statement

What am I missing here? This code used to work fine on another server.

It says use an updateable query, and my query is updatable.

Any help would be appreciated.

Nov 24 '05 #4

P: n/a
Welll I know nothing about asp but an update query doesn't return records so
I would look at changing
set rstemp3=conntemp3.execute(sqltemp)

to
call conntemp3.execute(sqltemp)
--
Terry Kreft

"Web Search Store" <in**@websearchstore.com> wrote in message
news:uH**************@TK2MSFTNGP15.phx.gbl...
I'm getting this error on my web page:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/searchweb33.asp, line 5014

Here is the code producing it:

myDSN="d:\data\main_database.mdb
set conntemp3=server.createobject("adodb.connection")
conntemp3.Mode = 3 '3 = adModeReadWrite
conntemp3.open myDSN
sqltemp="update [db_version_table] set db_title='used'"
set rstemp3=conntemp3.execute(sqltemp)

The error is produced on the execute statement

What am I missing here? This code used to work fine on another server.

It says use an updateable query, and my query is updatable.

Any help would be appreciated.

Nov 24 '05 #5

P: n/a
Hello Patrick,

Thanks very much. Your blog entry led me to get the problem solved. (The
problem resulted from creating the folder from a different machine, so it
inherited all the permissions from the other machine, which were incorrect.
Once I could reveal the 'security' tab, I changed to folder permissions to
match the ones on the other machine.

Thanks again!

Scott
"Patrick.O.Ige" <pa********@optusnet.com.au> wrote in message
news:u5**************@TK2MSFTNGP12.phx.gbl...
I blogged how to solve your problem at:-
http://spaces.msn.com/members/naijacoder
Hope that helps
Patrick

"Web Search Store" <in**@websearchstore.com> wrote in message
news:uH**************@TK2MSFTNGP15.phx.gbl...
I'm getting this error on my web page:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable
query.
/searchweb33.asp, line 5014

Here is the code producing it:

myDSN="d:\data\main_database.mdb
set conntemp3=server.createobject("adodb.connection")
conntemp3.Mode = 3 '3 = adModeReadWrite
conntemp3.open myDSN
sqltemp="update [db_version_table] set db_title='used'"
set rstemp3=conntemp3.execute(sqltemp)

The error is produced on the execute statement

What am I missing here? This code used to work fine on another server.

It says use an updateable query, and my query is updatable.

Any help would be appreciated.


Nov 26 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.