>The problem.
>We added more tables to our .DBC and changed the field names on some tables that were already in the .DBC. When we look in Visual InterDev's data environment, we see the table additions and field name changes. However, when we run the .ASP pages that should collect the data, the ADO code can't find the tables/field name changes.
>
If your data is located on the same server, why not using VFP5.0 to access the data from the ASP page. This is what you can do. Create a exe in VFP5.0 and Build it as a COM server or OLE server. The in you ASP page you call you FoxPro OLE server by creating the OLE server object ex: oMyVFPServer = CreateObject("MyOleServer.Server")
In you Ole Server Object you place custome method to query you data.
Ex:oMyVFPServer.Query("client.ID=204")
To know more lock in the VFP Developer's Guide page 438 Creating OLE Server
You can also find sample code I done for MFUG at
http://www.softdesign.qc.ca/Present.htmlThis will give you a faster solution to access you data from the Web.
Good Luck!