greisch
asked on
ADO - Clipper
I am trying to modify records in a Clipper Database using ADO.
I tried with an SQL UPDATE in a connection execute.
I tried with a recordset.
When I try to update I receive an error 80004005 : Operation must use an updatable query.
The connection mode is read/write.
When I ask if the recordset supports update it replies True.
I try a Dynamic, Keyset recordset.
I have always the same error.
Has Anyone an idea ? If possible, I don't want to use DAO (I have not tried yet and I don't want to).
Thanks in advance.
I tried with an SQL UPDATE in a connection execute.
I tried with a recordset.
When I try to update I receive an error 80004005 : Operation must use an updatable query.
The connection mode is read/write.
When I ask if the recordset supports update it replies True.
I try a Dynamic, Keyset recordset.
I have always the same error.
Has Anyone an idea ? If possible, I don't want to use DAO (I have not tried yet and I don't want to).
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check to make sure that permissions are set properly on the database. If you don't have write permissions on the database then you will get that error.
ASKER
I deleted references to DBase files in ODBC then set them up again.
Now all works fine.
Thanks.
Now all works fine.
Thanks.
200 points have been refunded to you, the grade changed from "C" to an "A". Thanks for posting the solution (workaround) you found outside the direct result of recommendations made here. Rather than deleting it, we will keep this in our PAQ (Previously Asked Questions), since your own solution can help others. Those asking questions cannot also be the ones granted with the Accepted Answer.
If you have any questions in this regard, please let me know.
Moondancer - EE Moderator
If you have any questions in this regard, please let me know.
Moondancer - EE Moderator