Making read-only recordset updatable
Posted on 2006-04-11
I'm looking for a way to change a read-only recordset into an updateable one.
The application queries several tables and, due to the links, returns a non-updateable result.
I then disconnect this (ActiveConnection=Null) and want to edit the results for a report, but I can't see a way of changing the results table.
I've tried saving it as a persisted recordset and reopening as editable, but it still remembers that it cannot be updated.
Anyone any clues?