Hi,

Wondering if it might be different TABLEVALIDATE settings ?
Regards,
Viv


>Okay, I give. I know there has to be a thread around here that addresses this issue, but have yet to figure out my problem. Here's the deal, I have a VB6 app that pulls data from a VFP9 table
>
>Dim rstTLVTable As New ADODB.Recordset
>
>strQuery = "Select * From FoxProTableName Where FieldXYZ = " & _
>SingleQuote & m_colIvoc(intInnerIndex).XYZValue & SingleQuote
>
>rstTLVTable.Open strQuery, m_adodbFoxPro, adOpenStatic
>
>m_adodbFoxPro is defined as "\\server\directory\subdirectory\"
>
>When this is attempted, I get an error message
>"An error has occured in the program and is forced to shutdown. Cannot open file \\server\directory\subdirectory\FoxProTableName.cdx" and yes the cdx is in the same directory as the dbf.
>
>Here's the real puzzling piece. It works fine on the development system which has VFP9 loaded. It is only on the systems with Runtime that I get the error. I believe all are at same MDAC level. I thought it might be the VFP driver (Development 6.01.8630.01) but have a mix of systems with 6.01.8629.01 and 6.01.8630.01 that have the same issue.
>
>My hair is getting thinner as I try to figure out this thing. Help.