>Hi all.
>
>I'm using the DAO control in VB5... I get an error message if i try to open a Foxpro DBF that contains a long file name. The message i get is "Microsft jet database engine could not find the object "FILENAME" ....."
>
Carl, with tables created by VFP 3.0 or later, the Jet engine is probably the wrong choice; the header information is different, especially with tables that are a part of a .DBC, and new data types are supported.
I'd recommend using ADO and the VFP ODBC driver that comes in the MDAC or with Studio.