Updating access data from foxpro
Most evident in several changes to the data engine, Visual Fox Pro 9 includes many enhancements for data access and database application development.
Visual Fox Pro 9.0 contains more functional enhancements to the data engine than any release since 3.0.
After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.
Connection information is stored in the workbook and can also be stored in a connection file, such as an Office Data Connection (ODC) file (.odc) or a Data Source Name file (.dsn).
Changes to the data engine can be summarized in five major areas: Many of these changes improve the Visual Fox Pro 9 client/server story by providing stronger interoperability with SQL Server.
With support for new data types and removing many limits from the SQL language, it's now easier to develop a single code base that works with the Visual Fox Pro 9 native data engine and SQL Server. Certainly the best word to describe changes to the SQL sub-language is MORE!
A single SQL SELECT statement can contain more tables, more JOINs, more sub-queries, more nested sub-queries, and more UNIONs than ever before.I have worked out on that and I can successfully read from Foxpro for this. is I have to write back to foxpro-for the updation of new employees so that their attendance cards can be read. Connection is opened, the recordset is read, but when i use update command-it gives me the error: Recordset doesn't support this property. This means that your transactions will be much slower, regardless of what operation you are undertaking.