We are finally replacing our DAO Grid with the ODBC one. Previously the DAO version would allow SQL that included JOINs to display in the grid and allow the results to be updated directly.

CRecordset (through CGXDynamicRecordset) sets the recordset updateable == FALSE when the SQL query contains a join.

I have confirmed using the debugger that allowing the recordset to be 'updateable' doesn't cause any problems (at least with our queries),
but the "updateable" member variable is protected and the relevant function is not virtual so can't be overidden.

How can I retain the old behaviour when using the ODBC grid?