I would like to open and update a paradox table from Visual Basic. I have made a working demo which reads the paradox table (.db file) using the ADO Data Control.
I have a DataGrid Control bound to this ADODC.
When I set the LockType to adLockPessimistic I am able to edit the fields in the DataGrid.
However, when I close my application it does not save my changes to the table.
I've tried calling ADODC.Recordset.Update and ADODC.Recordset.UpdateBatch but it doesn't work.
It keeps telling me it has not enough of properties to update the table.
Does anyone knows how to handle this? How can I update a specified record in a paradox table?
NOTE: The table has no primary index or unique identifier. I'm not sure, but this might be a problem. It is not possible to add one because the data is exported from another application...