Hi David,
Why do not you include the full path to your tables in connection string?
You have to include it:

...
cn1.Open ...;SourceDB=FullPathToYourTables;...
...

With best regards,
Alex

>I am having some challenges with making a connection to a Visual FoxPro free table on the web. Actually, I need to access 2 tables and make a join. I am getting a Fox error 1 with the code below:
>
>

>set cn1 = Server.CreateObject('ADODB.Connection')
>cn1.Open 'Driver={Microsoft Visual FoxPro Driver};' & _
>                   'SourceType=DBF;' & _
>                   'SourceDB=\;' & _
>                   'Exclusive=No;'
>set rs = cn1.Execute ( 'select * from table1' )
>WHILE NOT RS.EOF
>     Response.Write ( '<tr<td' _
>     & rs('field1') & '</td<td' _
>     & rs('field2') & '</td<td' _
>     & rs('field3') & '</td<td' _
>     & rs('field4') & '</td</tr' )
>     rs.MoveNext
>WEND
>

>
>Any ideas?
>TIA!