Hi,
I tried using below thing but mdb database is not getting updated.
CDBPropSet ps(DBPROPSET_ROWSET);
ps.AddProperty(DBPROP_IRowsetChange, true)
ps.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE)
However, I am able to update the database using CRowset::SetData
Please guide me if "update <Table> ...' query can be executed or we need to update DB using CRowset::SetData only.