Must use an updateable Query error message - HELP!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not a programmer, but a rookie. I am trying to use a DS in Visual Studio .Net 2003 to make changes to an Access database. I get an "Operation must use an updateable query" error message. I do not know where I would add the code for an update query. I thought VS .Net creates the update, delete, and insert statements for you when you create the original Select statement. I have been typing the code, not using the drag & drop method. My Select statement used one variable to know what record to grab from teh data set. I need to do this for work,,, so I really need to figure this out.

I want to be able to use a aspx web page to manipulate an Access database on the server. I do not know what code to type for the update statement or where to put it. Here is my select statement code.

SelectStatement = "Select AdNum, Description, Title, Category, Price, Phone, EMail, State, Password, Posted From Ads Where AdNum =" & "'" & AdNumSent & "'" & "order by AdNum

Like I said, I am not a programmer yet, any help would be much appreciated

(e-mail address removed)
 
Hi Topher,

Do never add a question to another question, not nice for the Original
Poster OP.

He thinks he get an extra answer now.

Have for your problem a look to this

http://msdn.microsoft.com/library/d...temdataoledboledbcommandbuilderclasstopic.asp

Some guys from the ADONET newsgroups say that it is buggy with and I thought
that it was with the JOIN.
However that JOIN does not work with Access, so that should not be a
problem, however keep track of it.

I hope this helps?

When it does not help create a "new" message in this case.

Cor





Topher Strugles said:
I am not a programmer, but a rookie. I am trying to use a DS in Visual
Click to expand...
Studio .Net 2003 to make changes to an Access database. I get an "Operation
must use an updateable query" error message. I do not know where I would
add the code for an update query. I thought VS .Net creates the update,
delete, and insert statements for you when you create the original Select
statement. I have been typing the code, not using the drag & drop method.
My Select statement used one variable to know what record to grab from teh
data set. I need to do this for work,,, so I really need to figure this
out.
I want to be able to use a aspx web page to manipulate an Access database
Click to expand...
on the server. I do not know what code to type for the update statement or
where to put it. Here is my select statement code.
SelectStatement = "Select AdNum, Description, Title, Category, Price,
Click to expand...
Phone, EMail, State, Password, Posted From Ads Where AdNum =" & "'" &
AdNumSent & "'" & "order by AdNum"
 
I do not see why this message did show up the first time in my OE on an
different thread, however please forget the first and the last lines.

Cor
 
Back
Top