Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Updateable Query Problem


Message #1 by "Mark Irvine" <mark@m...> on Fri, 30 Mar 2001 13:58:13
Hi All,



I was just wondering if anyone could explain why I am getting this error 

message:



Error Type:

Microsoft JET Database Engine (0x80004005)

Operation must use an updateable query



I am aware that this usually occurs when the folder, holding the database, 

is not write enabled.  However in this it is, I specifically logged in as 

the Admin and changed it, yet the error still persists!



Any help would be greatly appreciated



Mark



PS



I uploaded to my ISP' server and it ran as it should.
Message #2 by "Blake, Shane" <Shane.Blake@p...> on Fri, 30 Mar 2001 09:51:14 -0500
this does sound like a permissions problem... 



but we need more info...



is the db on the machine as the web server? 



does iusr_<machine name> have rights to the .mdb and the folder?



some code?



shane



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

From: Mark Irvine [mailto:mark@m...]

Sent: Friday, March 30, 2001 8:58 AM

To: ASP Databases

Subject: [asp_databases] Updateable Query Problem





Hi All,



I was just wondering if anyone could explain why I am getting this error 

message:



Error Type:

Microsoft JET Database Engine (0x80004005)

Operation must use an updateable query



I am aware that this usually occurs when the folder, holding the database, 

is not write enabled.  However in this it is, I specifically logged in as 

the Admin and changed it, yet the error still persists!



Any help would be greatly appreciated



Mark



PS



I uploaded to my ISP' server and it ran as it should.





Message #3 by "Mark Irvine" <mark@m...> on Fri, 30 Mar 2001 17:43:33
shane,



Many thanks for your reply!  Yes it was a permissions problem, I thought 

as I was able to read from it then the suitable permissions would be set.  

Previously I did all my development on Win98SE with PWS, the security 

settings is something I continue to overlook.



Mark



PS Thanks again!!



> this does sound like a permissions problem... 

> 

> but we need more info...

> 

> is the db on the machine as the web server? 

> 

> does iusr_<machine name> have rights to the .mdb and the folder?

> 

> some code?

> 

> shane

> 

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

> From: Mark Irvine [mailto:mark@m...]

> Sent: Friday, March 30, 2001 8:58 AM

> To: ASP Databases

> Subject: [asp_databases] Updateable Query Problem

> 

> 

> Hi All,

> 

> I was just wondering if anyone could explain why I am getting this error 

> message:

> 

> Error Type:

> Microsoft JET Database Engine (0x80004005)

> Operation must use an updateable query

> 

> I am aware that this usually occurs when the folder, holding the 

database, 

> is not write enabled.  However in this it is, I specifically logged in 

as 

> the Admin and changed it, yet the error still persists!

> 

> Any help would be greatly appreciated

> 

> Mark

> 

> PS

> 

> I uploaded to my ISP' server and it ran as it should.

> 

> 


  Return to Index