Error Type:Microsoft JET Database Engine (0x800040

Stefanoz · February 25th, 2006, 03:43 PM

I have tried the code presented in the book Beginning Active Server Pages 3.0 on the chapter 14. The code in question is the SQLUpdate.asp where it tries to update a fields in the movie2000.mdb database. I have tried also the code given for download and I ge the same error message:

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/begASP/SQLUpdate.asp, line 22

Pleas Help I don't know what's wrong.

I have checked the permissions and on both the server and windows are set for read and write

Dj Kat · February 26th, 2006, 10:10 AM

Hi Stefanoz,

First off all have you created a odbc connection in windows. And are you using Odbc connection code in your asp code.

The reason I ask this is there is a big difference between mysql wich is most common and a acces database wich you are using.

This is what your asp code should look like

Code:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
%>

Or like this with a odbc connection:

Code:

<%
set conn=Server.CreateObject("ADODB.Connection") 
conn.Open "northwind"
%>

hope this helps

__________________________________________________ ________
This is my junk I'm gona eat it

mat41 · February 26th, 2006, 06:07 PM

;;;I have checked the permissions and on both the server and windows are set for read and write

Permissions for which user? IUSR privileges must be set to "read/write".

Wind is your friend
Matt