Visual Fox Pro vs Access

How does visual foxpro compare to access? does anyone know how they are different. Is one more powerful / faster than the other? Why do microsoft have 2 database programs? i fugure there must be some differences between them..

Also, i've heard that Visual Foxpro is on the way out...like will not be supported much longer by microsoft, does anyone know if this is the case?

Reason: a friend has a business running v foxpro and wants to know if they should convert to VB/access

thanks in advance,

I've been working for a company for over a year. When I first began, every application was written in VFP. VFP is faster than Access (I'm almost positive) and VFP is better in multi-user environments. I did some development within Visual FoxPro and found that it was pretty crappy. We purchased Visual Basic after and now I use VB to connect to VFP databases and have no problems. The only thing that sucks is when I have to use Visual FoxPro to view tables and create queries because the VFP interface is a little buggy.

Very good,

Thanks for the info...

VFP is dead. Let me know if you see a VFP-2000 (or higher) show up in the stores.

ANY good links on vb and foxpro?
or am i just on my own :)??

all i want to do is append data from a file
into a foxpro table from vb

I think you're pretty much on our own when it comes to VB and VFP. I haven't found very much. It's not too difficult though.

I use the ADO data control to build my connection string. From there I do a lot with the Execute method.

Code:

---

    strOpenClosePath = "\\NORTHERN_REHAB\SYS\VFP\FO\newdata\openclose.DBC"
    strConnString = "Driver={Microsoft Visual FoxPro Driver};UID=;"
    strConnString = strConnString & "SourceDB=" & strOpenClosePath
    strConnString = strConnString & ";SourceType=DBC;Exclusive=No;"
    strConnString = strConnString & "BackgroundFetch=Yes;Collate=Machine;"
    strConnString = strConnString & "Null=Yes;Deleted=Yes;"

    Set cnnConnect = New ADODB.Connection
    cnnConnect.Open strConnString
   
    strSql = "SELECT file_num, infile_num, claimant FROM nrcs "
    strSql = strSql & "WHERE infile_num='" & Trim(txtClaimNum.Text) & "' "
    strSql = strSql & "AND left(nrcs.client_num,3)='WSI' "
   
    Set rstCurrent = New ADODB.Recordset
    rstCurrent.CursorLocation = adUseClient
    rstCurrent.Open strSql, cnnConnect, adOpenStatic, , adCmdText

---

You can also use the execute method to issue VFP commands

Code:

---

        cnnConnect.Execute ("PACK adjuster.dbf")

---

Good Luck.