Hi Nick,

This is a security issue. Make sure that the account that IIS is running 
under (usually ISUR_MachineName) has sufficient rights to the database. It 
needs at least change permissions on the database, but usually also on the 
folder it resides in to create temporary files (like .ldb for an MS Access 
scenario)

HtH


Imar


At 09:37 PM 1/31/2003 +0000, you wrote:
>Hello all!
>
>I recently acquired a new XP Professional machine, and transfered there
>my ASP application which was previously working properly in my W2K
>Professional machine.
>
>I think i configured IIS properly on the new machine but my problem is, i
>cannot update my database (insert, update, delete). Strange is, my
>selects work fine in any page but not the updates. When updating-
>inserting, i receive "Error Type:Microsoft JET Database Engine
>(0x80004005)Operation must use an updateable query."
>
>When deleting: "Error Type: Microsoft JET Database Engine (0x80004005)
>Could not delete from specified tables."
>
>Any ideas on how to fix this?
>
>Thanx in advance
>
>Nick

Thanks Imar for the response. When i was working under W2K Pro setting 
the appripriate permissions was a piece of cake. Now, under XP I cannot 
find the "Security" tab when right-clicking
or any other way to set the user's rights. Have any idea?

Nick

> Hi Nick,
>This is a security issue. Make sure that the account that IIS is running 
>under (usually ISUR_MachineName) has sufficient rights to the database. 
>It needs at least change permissions on the database, but usually also 
>on the 
>folder it resides in to create temporary files (like .ldb for an MS 
>Access scenario)

Hi Nick,

Under XP this tab is hidden by default. Open a Windows Explorer, go to 
Tools | Folder Options, on the View tab scroll down and clear the checkbox 
for "Use Simple Sharing" (be sure to read some of the help to understand 
the consequences).

Now, the Security tab will be available.

Cheers,

Imar


At 11:47 AM 2/2/2003 +0000, you wrote:
>Thanks Imar for the response. When i was working under W2K Pro setting
>the appripriate permissions was a piece of cake. Now, under XP I cannot
>find the "Security" tab when right-clicking
>or any other way to set the user's rights. Have any idea?
>
>Nick
>
> > Hi Nick,
> >This is a security issue. Make sure that the account that IIS is running
> >under (usually ISUR_MachineName) has sufficient rights to the database.
> >It needs at least change permissions on the database, but usually also
> >on the
> >folder it resides in to create temporary files (like .ldb for an MS
> >Access scenario)

hi,
   Finally Khalnayak is HEre.
ur sol is ur db have no rights for updation.
Give Rights 2 ur DB for updation everyone,ALL,Administrators and more options
u can see these options from
right click on ur db options then go 2 properties
then securities option and click all options of read write permissions

Db->Properties->Securities
 thr r 2 boxes in the name section u will see all User names of ur system and in 2nd box u will see permission option Now
click on 1 by 1 user name and in below box click on all boxex like
Full Control
write
read and more..
now do this on every user 1 by 1 ur prob solved now
bye
have a nice day
khalnayak is Great

--

On Fri, 31 Jan 2003 21:37:15  
 Nick wrote:
>Hello all!
>
>I recently acquired a new XP Professional machine, and transfered there 
>my ASP application which was previously working properly in my W2K 
>Professional machine.
>
>I think i configured IIS properly on the new machine but my problem is, i 
>cannot update my database (insert, update, delete). Strange is, my 
>selects work fine in any page but not the updates. When updating-
>inserting, i receive "Error Type:Microsoft JET Database Engine 
>(0x80004005)Operation must use an updateable query."
>
>When deleting: "Error Type: Microsoft JET Database Engine (0x80004005) 
>Could not delete from specified tables."
>
>Any ideas on how to fix this?
>
>Thanx in advance
>
>Nick
>


_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus