sqloledb

[KPL]

when i connect to my sql database with vb by using micro soft activex data object 2.1 library i can view only the table but not able to modify it.when i try to add,save,update or delete it will show an error message
like "the operation requested by the aplication is not upport by the provider".why it is show this err msg,pls explain me in detail

 

[Bickle]

You probably need to look at your parameters when you try to open the recordset.

For example

recordset.Open Source, ActiveConnection, CursorType, LockType, Options

If the LockType is ReadOnly, you can't use Delete, Add new etc.

I hope this helps