Operation must use an updateable query.

[krunom]

I use asp to write something in database, but then i get error message:
Operation must use an updateable query.

and this error is appearing in line "conn.execute sql"...

i read that this error can happen if the folder with database isnt good set,
and that I must set security options for this folder... in my last post i
asked how to get this security options (and i hope u answered me), but now i
ask if you have some other ideas to solve this problem with sql....thanks

 

[Robert Moir]

I use asp to write something in database, but then i get error
message: Operation must use an updateable query.

and this error is appearing in line "conn.execute sql"...

i read that this error can happen if the folder with database isnt
good set, and that I must set security options for this folder... in
my last post i asked how to get this security options (and i hope u
answered me), but now i ask if you have some other ideas to solve
this problem with sql....thanks

Presumably you are talking about an Access database? (You might considering
mentioning details like this in the future instead of leaving people to
guess).

If you are using access then ensure that the IIS user account has the
ability to create and modify in the access database's home folder then it
will be able to generate the ".ldf" lock file that access use requires.

--
--
Rob Moir, Microsoft MVP for servers & security
Website - http://www.robertmoir.co.uk
Virtual PC 2004 FAQ - http://www.robertmoir.co.uk/win/VirtualPC2004FAQ.html

Kazaa - Software update services for your Viruses and Spyware.

 

[krunom]

Presumably you are talking about an Access database? (You might considering
mentioning details like this in the future instead of leaving people to
guess).

If you are using access then ensure that the IIS user account has the
ability to create and modify in the access database's home folder then it
will be able to generate the ".ldf" lock file that access use requires.

thanks... problem fixed...