>Hi All,
>
>Let me first start by stating that I'm a Foxpro person through and through... love the product... always will.
>
>I'm employed with a small shop that has applications written in Visual Basic 6.0 accessing an Access Databases. Problem being that database is too slow and can't handle a larger number of records. I suggested using Visual Foxpro as the Database. Actually stuck my neck out a bit on this one.
>
>We've encountered numerous problems with ADO and Visual Foxpro Tables. Where can I get some examples of Using.... sorry to say Visual Basic using ADO accessing and updating Visual Foxpro 7.0 Database Container and it's tables.
>I'm hoping we can write Visual Foxpro & Visual Basic Applications that access the same Database being Visual Foxpro.
>
>thanks in advance,
>
>Don
Hey Don,
Nothing to be sorry about. I more and more use C#.NET (with or w/o conjunction to VFP) and what, am I a traitor:)
ADO access to VFP using either VFPOLEDB (preferred) or MSDASQL is straight forward. Is there anything specific you're asking?
A simple code updating employee (will write VFP style naturally, I can't dim:)
oConn = createobject('ADODB.Connection')
oConn.ConnectionString = "Provider=VFPOLEDB;Data Source=c:\myPath\TestData.dbc"
oConn.Open
oConn.Execute('set null off')
oRS = oConn.Execute("insert into employee (emp_id,First_name,Last_Name)"+;
" values ('xxx','Don','Weaver')")
oConn.Close
Cetin