>I'm working with KB article Q172592: HOWTO: Open a Visual FoxPro Table for Read/Write.
>
>In the example code, that they give you, they show the following syntax for opening a table.
>
>Set rs = cn.OpenResultset(SQL, rdOpenKeyset, rdConcurRowVer)
>
>When I try these parameters, I get an ODBC Error: 'Driver Not Capable'
>
>What I need to be able to do, is open a VFP 5.0 table and be able to EDIT it. I can open readonly with no problem.
If that causes you a problem, you may create a Visual FoxPro DLL that will allow you total control of it by using Visual FoxPro command from Visual Basic. I did that once because they was a lack of control in VB and it was the perfect solution for us to do. The VFP DLL was extremly simple by allowing us to establish an object with VFP and doing VFP commands from there.