Hi Cetin,

Very cool... I will play with this and get back to you.

Dr. G. (neil)

>>Hi,
>>
>>I have a client with a fpw26 application, whose data is in 25 free tables. There is no DBC. How do I set up the vfp OLEdb data provider to access **all** of the free fpw26 data tables. I only need to read the data. I want to access the data via an ASP.net application so I want to use the vfp data provider.
>>
>>Thanx,
>>Neil
>
>Neil,
>DBC doesn't need to be something related with tables. Put any dbc there (ie: Create and put a dummy.dbc)
>
>

>'....
>    dbpath = Server.MapPath("data")
>    set oConnection = Server.CreateObject( "adodb.connection" )
>    with oConnection
>       .ConnectionString = "Provider=VFPOLEDB.1;data source=" &_
>          dbpath & "\dummy.dbc"
>       .Open
>       .Errors.Clear	
>       Set rs = .Execute( "select * from c:\myPath\MyFox2xFreeTable" )
>    end with
>'....
>

Cetin