<div>
Yes this seems to work fine I prsume that append/update/delete will work just the same?
</div>


Yes this seems to work fine I prsume that append/update/delete will work just the same?

<div>
That is a reasonable assumption.
</div>


<div>
<div class="content wysiwyg-content">
I'm trying to open a foxpro DBF in vb6 and then use sql to open a record set/delete records/appen records/update records, so far all I have managed to do is open the dbf, dont seem to be able to do anything else??<br />

<pre><code id="code-59017">Mydb.Open &quot;DSN=Visual FoxPro Tables;UID=;PWD=;SourceDB=&quot; &amp; _
    App.Path &amp; &quot;\mom_import.dbf&quot; &amp; _
    &quot;;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Nu    ll=No;&quot; &amp; _
    &quot;Deleted=Yes;&quot;
    sqlStr = &quot;SELECT * from mom_import.dbf&quot;
    rst.Open sqlStr, Mydb, adOpenForwardOnly, adLockReadOnly, adCmdText
</code></pre>
</div>
</div>


I'm trying to open a foxpro DBF in vb6 and then use sql to open a record set/delete records/appen records/update records, so far all I have managed to do is open the dbf, dont seem to be able to do anything else??

open dbf in vb6 and open recordset

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.