>My apologies if this question could have been posted elsewhere.
>
>I'm having a pretty difficult time trying get my head around how ADO in ASP is accessing Foxpro2.6 tables.
>
>Three Questions:
>1.What's the best coding method to setup and use an updatable recordset in ASP for Foxpro 2.6 tables
>2.Is there any resources/examples on the net?
>3.Is there any specification document that outlines what features are and aren't supported in ADO when accessing Foxpro 2.6 tables.
>
>I am using the following provider
>"Provider=MSDASQL.1;Persist Security Info=False;Data Source=FoxproData;"
>Any help would be greatly appreciated
>
>Thanks in advance
>
>George

I don't think you will find anything specific for Fox2.6 tables. You might want to try whatever is available on accessing free tables with ADO to see if the FoxPro version that created the tables makes any difference.

I would recommend starting with the ADO Jumpstart by John Petersen at http://msdn.microsoft.com/library/en-us/dnfoxgen/html/adojump.asp and following up with these MSKB articles:
http://support.microsoft.com/support/kb/articles/Q191/4/13.ASP on using offline ADO recordsets.
http://support.microsoft.com/support/kb/articles/Q165/4/92.ASP on using a VFP database with ADO. The syntax to use free tables is very similar, you just need to change a couple of parameters on the connection string to point to a free table directory.
http://support.microsoft.com/support/kb/articles/Q195/0/82.ASP another one on disconnected and persisted recordsets.

Hopefully in these examples you will find something to update a free table with ADO. Upon trying just comeback and post the specifics of the roadblocks and for sure someone will chime in and help.

If you already have some code that is not working post it here and also the error message and maybe me or someone else can help.