>>>>>Hi all,
>>>>>
>>>>>I am trying to import/link a vfp table from Access 2000 through odbc.
>>>>>I have been successful with VFP DBC tables, but not with Free Table directory.
>>>>>I got this error message : "Reserved error (-7778) there is no message for this error" from Access 2000.
>>>>>I am using Microsoft Visual Foxpro Driver version 6.00.8428.00 dated 04/06/99.
>>>>>Any idea?
>>>>>
>>>>>Thanks.
>>>>>
>>>>>Kam.
>>>>
>>>>Are you accessing the free table directory programmatically or with a remote query (ODBC)?
>>>>
>>>>FWIW, there is a newer version of the driver at :
http://www.msdn.microsoft.com/vfoxpro/downloads/odbc.asp>>>
>>>Hi Crescencio,
>>>
>>>I am doing it from within Access by linking it.
>>>Thanks for your reply.
>>>
>>>Kam.
>>
>>If I remember correctly, the table link in Access uses the Jet engine instead of the ODBC driver. And also if I'm not mistaken, the Jet engine only supports up to FPW2.6 tables. This has been since Acc97 and I don't think they added this support on A2K.
>>
>>If you want to open this you need to go with a query based on the ODBC driver or use the COPY TO .. FOX2X to save your VFP table with the required format. I think there is a KB article about this. I'll see if I can dig it up.
>>
>>HTH
>I am linking via VFP ODBC using a DSN defined from VFP ODBC driver.
>My problem is that it gave me error trying to access a free table. And it
>is fine while accessing a VFP DBC/tables.
>Strange, isn't it ?
>
>Kam.
See also this MSKB article:
http://support.microsoft.com/support/kb/articles/Q212/8/86.ASP