I got this message when I try to add/update/delete record from the database.

"[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query."

Any idea?

Please help. urgent

Hi rycbn,

try this link, quite a good explanation.

support.rjsnetworks.com/support/web/answertrackloader.asp?action=kbprint&kbid=5

Digga

Sharing Knowledge Saves Valuable Time!!!

What type of database object is it?

if it s a query then make sure you can insert to it, if the query has any kind of totaling or grouping then it may not allow inserts.

try inserting in MS Access, if it works there it'll work in your App.

Cheers

LEED

:: Son, im Thirty.... ::

Thanks guys. Problem solved.

\(^o^)/

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
hi roger,
how do you find the solution of the problem "Operation must use an updatable query"
please tell me in detail.
i am using asp.net2003,C#,MS Access
my application working on local host properly.edit delete working on local server.but when i upload it on web server it retrieve data from dabase and showing in grid.but edit and delete query not working on it.

\(^o^)/


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

live_n_letlive