Can't update DB Help!!!

dekel78 · August 13th, 2004, 10:42 AM

when I write:
MyRs.Update I getthe followinf message:

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

Best regards
Dekel

happygv · August 13th, 2004, 01:27 PM

Hi Dekel,

How is that you open youe MyRs recordset? This is how is should be for any Add/Update/Delete operations. See the one marked in RED below.

Code:

MyRs.Open "Select * from TestTable", ObjConnection, adOpenKeyset, adLockOptimistic

Check if you are using the correct lock type.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection