andrevanderplas
asked on
Paradox db with ADODC ??
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.UpdateBatc h 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...
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.UpdateBatc
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...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi andrevanderplas,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept TimCottee's comment(s) as an answer.
andrevanderplas, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept TimCottee's comment(s) as an answer.
andrevanderplas, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
==========
DanRollins -- EE database cleanup volunteer
Comment from expert accepted as answer
Computer101
E-E Moderator
Computer101
E-E Moderator
ASKER