在VFP中如何实现压缩ACCESS数据库

我现在用VFP做了一个程序,用的是ACCESS数据库,但体积越来越大,我想在VFP中用ADO以代码方式实现压缩和修复ACCESS 数据库,不知道该怎么实现
---------------------------------------------------------------

*DAO方式:

LOCAL lole
lole=CREATEOBJECT('DAO.DBEngine.36')
lole.COMPACTDATABASE('D:\TEMP\TEST.MDB','D:\TEMP\NewTable.MDB')
RELEASE lole

-----------------------------------------------

*ADO方式:

LOCAL lole
lole=CREATEOBJECT('JRO.JetEngine')
strS1="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TEMP\TEST.MDB;;Persist Security Info=False;Jet OLEDB:Database Password=;"
strT1="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TEMP\NewTable.MDB;Jet OLEDB:Engine Type=5;"
lole.CompactDatabase(strS1,strT1)
RELEASE lole

Published At
Categories with 数据库类
comments powered by Disqus