Ok, here is what is supposed to happen. a Single record is retrieved from a table, and is stored inside a textbox(textbox1), in another textbox(textbox2) is a value. I want the value inside textbox2 to appear in textbox1, and then update the record in the database with the new value in textbox1.

I can do all up to updating the record, where im being given the "Operation must use Updatable Query".

since this is such a small program, and has 3 functions, i've kept the adodc1 caption.

adodc1.recordset.update is what i am trying to use to update the db.

What am i doing wrong?

(Microsoft Jet 4.0 is used.)

hi there...

what table or query are you using to open the data??

what type of query is the adodc using??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

I am getting the same problem with the following 'simple' query that is being run in Access VBA code connected to a SQL database. I have changed the exact details to better show the query...

UPDATE [TABLE] set [COLUMN] = '[VALUE]'
UPDATE utility set appversion = '5.10.46'

I can see nothing out of the ordinary here. The connection is via ODBC, which tests okay when created. I have connected to SQL (in Query Analyzer) with the same login credentials and executed the query there, with no problems.

Does anyone have a suggestion as to the solution?

Regards,

Sean Anderson

Is it possible that the account being used in these operations has permission to SELECT, but not to UPDATE? I don't know if SQL gives that level of resolution; Oracle does though.

Same question as above.. what type of recordset are you using to do the update??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========