-----Original Message-----

From: Ian Jarvis [mailto:ian@l...]

Sent: 19 June 2000 21:24

To: support@w...

Subject: error updating MS Access database





I'm having a problem updating a table in an Access database that's being 

used to drive a web site. I'm updating the database using ASP and a 

straight SQL update statement. When I run the update statement against the 

database running on my Persoanl Web Server at home, all works well. But 

when I upload the access database and ASP script to my website I get the 

following error message when I try and do the update statement...

 

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 



[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable 

query.



/admin/updateHotel.asp, line 51 







The ASP scripts that read the database work fine. It's only when I try and 

do the update that I  get the problem. I searched through your book 

"Professional ADO 2.5 RDS Programming with ASp 3.0" by John Papa, but can't 

find any reference to this type of problem.



Any ideas?



Thanks in advance



Ian Jarvis 



ian@l...

I have spent the past few weeks on this problem and know the exact solution.



You need to speak to your ISP and ask them to change the 'everyone' 

permissions on the folder that contains your database to at least 'Change'  

permissions.  The reason for this if you want to know is that when Access is 

updated it needs to create an .ldb file, therefore you need to have write 

permissions to the folder so that it can write this temporary file to the 

folder.



Hope this helps



Alan

Usually cause by one of the following problems:



The IUSR_computername account on the host does not have CHANGE permissions

to the database



You are sending a malformed query to the database



I suggest that you post some code.



Also, don't use ODBC, use the native OLEDB Jet Provider - you will find that

things run faster, and you'll have less '80004005' Unspecified Errors



Cheers

Ken



> -----Original Message-----

> From: Ian Jarvis 

> Sent: 19 June 2000 21:24

> To: support@w...

> Subject: error updating MS Access database

>

>

> I'm having a problem updating a table in an Access database that's being

> used to drive a web site. I'm updating the database using ASP and a

> straight SQL update statement. When I run the update statement against the

> database running on my Persoanl Web Server at home, all works well. But

> when I upload the access database and ASP script to my website I get the

> following error message when I try and do the update statement...

>

> Microsoft OLE DB Provider for ODBC Drivers error '80004005'

>

> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable

> query.

>

> /admin/updateHotel.asp, line 51

>

Excellent chaps, thanks for that. I'll talk to my ISP tomorrow.



Advance thanks,



Ian