I'm using VB5 SP3 connecting to postgres database via ODBC.

I'm selecting record into a RecordSet as dynasets, but the RecordSet's Updatable property is FALSE even thought I've set the read only property of the ODBC driver on my PC to false and grant all permissions to public on that table.

How can I update this record set (insert, delete and update)? Or are there any more settings i need to do to be able to update this record set?

TIA.

Carolyn