What I was trying to do is run the asp code on the server. I do not know what the path is on the server. I just wanted it to use the local directory.

>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!