Connect to Dbase III with any data control or programmatically

[xan]

I have just started at a job that has been using primarily in-house DOS programs written in Clipper, using Dbase III databases. I am now starting to write some of their programs in VB 6.0, but they are leaving their Databases in Dbase (for now). I have been able to connect and display a Dbase III database using an ADODC and DBGrid, but it will not let me edit any fields. I get a 'not enough base table information for update or refresh' error. I have not successfully opened the database using DAO yet.<br>
Any tips would be useful.

 

[MPK]

I have connected to DBASEIII files using normal DataControl and not RDO/ADO, I could do the transaction as well, The only problem is I dont know the methodology to interface index files (NTX,CDX etc..)<br>
<br>
If you do not require index files, then normal datacontrol is fine for you, you can internally seek the record by using DATA1.RECORDSET.SEEK <br>
Use to add a new record DATA1.RECORDSET.ADDNEW<br>
To save a record DATA1.RECORDSET.UPDATE<br>
to Edit a record DATA1.RECORDSET.EDIT<br>
to delete DATA1.RECORDSET.DELETE<br>
Special care need to be taken after deletion , check help files.<br>
<p>Manoj Kalekar<br><a href=mailto:manoj_kalekar@yahoo.com>manoj_kalekar@yahoo.com</a><br><a href= > </a><br>

 

[33216CLC]

Hello xan,

I have a similar problem to yours. Could you please give a sample of the code you used to make the rdo/ado connection? I have attempted to to connect to a dbf file using vb6, but got an error stating that the I was using an unrecognized database format. Also, did the code Manoj give you work out ok?

Thanks,

Cooleen