473,387 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Operation must use an updatable query - user problem

Hello,

I have hosted my site in an hosting server.
I got the following message, while trying inserting a record to the database
:
Operation must use an updatable query.

For what I know, I need to change the permision for the user name :
IUSR_MACHINENAME, that can change the database file.

I made a full permission to that user for the database file.

.... but still I got the same massage as I titled above.

Please, help.

Thanks :)
Nov 17 '05 #1
1 1293
The problem is probably that the ASP.Net worker process doesn't use the
IUSER_... account (unless you specifically set it up to do so). It uses the
ASPNET account instead, unless your machine.config or web.config file states
otherwise.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.

"Mr. x" <a@b.com> wrote in message news:3f********@news.012.net.il...
Hello,

I have hosted my site in an hosting server.
I got the following message, while trying inserting a record to the database :
Operation must use an updatable query.

For what I know, I need to change the permision for the user name :
IUSR_MACHINENAME, that can change the database file.

I made a full permission to that user for the database file.

... but still I got the same massage as I titled above.

Please, help.

Thanks :)

Nov 17 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: David K | last post by:
Hello, I've been trying to make my db web applications to work in my test server and I keep getting this everytime I try to modidy the database: Microsoft JET Database Engine error '80004005'...
3
by: jallegue | last post by:
I am working with MS-Access 2002. The two tables that I am working with are: dbo_IDX_FRS_account_bal_by_month ==> this is a linked table to SQL == local table The query that is executed is...
0
by: CC | last post by:
Dear all, Following Many-to-Many table structure is part of my database ----------------------------------- TbGeneral (dossier information) PK: dsr_id TbDossierSample PK: dsr_sample_id
27
by: Bob | last post by:
running access 2k; mdb w/ linked tables to another mdb (front/back-end); trying to run a query that updates a table FROM information from a crosstab query. I AM NOTT trying to update the...
10
by: cyber0ne | last post by:
I'm having a bit of trouble adding records to a local .DB file (using a Paradox connection string). I checked the file permissions, and for testing purposes set Everyone to Full access. But it...
2
by: Enrique Rojas | last post by:
Hello I have this sql that triggers the abovementioned error. UPDATE ra SET ra.Year_1_Cost = (SELECT sum(conversion*Year_1_accom) AS year1 FROM accomfundlevels WHERE driver_id=168 And...
2
Ranjan kumar Barik
by: Ranjan kumar Barik | last post by:
Hello everybody ! I am trying to insert into an access table using ADO in ASP. But i am getting the error message: "Operation must use an updatable query". I have checked the security settings...
10
by: anniebai | last post by:
Can someone help me with this query, which gives the error message "operation must use an updatable query"? Thanks a lot. UPDATE publications set publications.pmcid = (select fname.pmcid from fname...
8
geolemon
by: geolemon | last post by:
I'm trying to perform an update, and I can't avoid this error - I've tried this query what must be 5 different very fundamentally different ways now. Arg. I used to be a DBA in large DB2 and SQL...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.