基于Visual FoxPro环境AeCESS数据库操作的实现

在Visual FoxPro中使用ACCESS数据库，能够克服其自奄存在的数据库、数据表与索引文件分离、数据表安全性不高等不利因素，较好地发挥二者在数据库管理与编程方酗的优势。鉴于这方面的资料较少，系统地阐述Visual FoxPm环境下ACCESS数据库的操作方法，实现在Visual FoxPro中ACCESS数据库的建立、压缩与修复；数据表的建立、结构与记录的维护；Visual FoxPro数据库与ACCESS数据库的相互转换、Visual FaxPro中通用字段与ACCESS中OLE字段的数据转换等方法是很多用户的客观需求。用Visual FoxPro编程方式全面操纵ACCESS数据库具有重要的理论与应用价值。

Realization of ACCESS Database Operations in Visual FoxPro Environment

Using the ACCESS database in Visual FoxPro, it can overcome the disadvantages of the separation of the database, data table and index file and the not high security of the data table and so on. it makes better use of database managements and programming in ACCESS and Visual FoxPro respectively. As the less information in this aspect, there are uses＇ objective demands that the ACCESS database operation methods are systematically demonstrated in the Visual FoxPro environment and they are implemented about the ACCESS database creation, the database compression and the database recovery in Visual FoxPro, the creation of data table, the maintenance about structures and records of data table, the mutual conversion of the databases between Visual FoxPro and ACCESS, the conversion of the general type in Visual ForPro to the OLE type in ACCESS and vice versa. It is no doubt valuable in the database theory and the application.