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.