Cannot locate the requested Xbase memo file

How are you establishing a connection?

What connectivity driver are you trying to use?  Based on the error message, you are not using the correct driver.

If you are using the dBASE driver that is freely floating around on most installations, it is not fully compatible with FoxPro tables (.dbfs), especially when a memo field is involved.

Download and install the free latest ODBC driver to use with FoxPro here:

Visual FoxPro ODBC Driver
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

I use Data1 and Properties set it to use DefaultType : 2-UseJet, Connect: Foxpro 3.0 and Recordset Type: 2-Snapshot.
I use Win2k and in the MSDN say I already got the latest Foxpro ODBC Driver. Pls advice. Thank you.

You said you got an error message similar to "Cannot locate the requested Xbase memo file".  If you were using the latest FoxPro ODBC driver (link that I posted above), that message would never come up.  You may think you have it installed and don't.  Or you may have it installed and you are not using the correct driver in this instance but a different driver that generally supports .dbf access, but not to the fullest extent as would the latest Visual FoxPro ODBC driver.

If you get to your W2K PC and go into Control Panel...Administrative Tools...Data Sources (ODBC), in the ODBC Data Source Administrator dialog/screen, you should be able to look for the driver.  If you choose the "Drivers" tab, you should look for entries like "Microsoft FoxPro VFP Driver (*.dbf)" and/or "Microsoft Visual FoxPro Driver".  If you have those, you have at least installed the driver.  If not, you don't have it installed yet on your PC.  If you have one or both of those designations installed, check out too the version number.  It should read something like 6.01.8630.01 or 6.01.8629.01.

Even after all of that, if you are not calling that driver, but another, you won't get the results you want.

Dear Carl,

Thank You for your help I got below driver,Pls advice which driver and how to apply it to my VB6 program??

Microsoft dBase VFP Driver(*.dbf)        6.01.8629.01
Microsoft FoxPro Driver(*.dbf)            6.01.8629.01
Microsoft Visual FoxPro Driver             6.01.8629.01

Thank you and Below is my code.


Private Sub Combo1_Click()
Dim strQuery As String
Dim criteria As String
Dim strQueryDesk As String

Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
List4.Clear


strQuery = "SELECT model, descrip1 From pl002 WHERE descrip1 = '" & Combo1.Text & "' And Model is Not Null ORDER BY model"


Debug.Print strQuery

List3.Clear
List2.Clear
Data2.RecordSource = strQuery '& criteria
Data2.Refresh
If Not Data2.Recordset.EOF Then

 Data2.Recordset.MoveFirst
 Debug.Print "am here"
    Do Until Data2.Recordset.EOF
         List2.AddItem Data2.Recordset("MODEL") & ""  
        Data2.Recordset.MoveNext
    Loop

End If

End Sub

Hi, Carl,

i fould the memo field file pl002.fpt and my program now work fine. It is all foxpro database will store memo field into one memo field and it don't sotre memo field into it database file .dbf.

thank you

Only a shell of a field is held in the structure of a .dbf for a memo field.  Because a memo field can contain pretty much unlimited contents, text or whatever you may want, the xBASE standard dictates that sort of free form non-structured data is held in the separate .fpt file.  dBASE, which was the basis for FoxBASE and FoxPro, is the system that started with that memo field design.  dBASE has a .dbt file.

Glad you got it all working.

Dear Carl,

thank you again. you really help me alot.

thank man.

It's OK.  You're welcome.  

I bet you thought you were going crazy. All it takes is one little thing to trip us all up. <s>