引用Microsoft Dao 3.6 Object Library对象
以下是代码:
Dim Db As DBEngine
Set Db=New DBEngine
Db.CompactDatabase App.Path & "\Data\Db.mdb",App.Path & "\Tmp.mdb" 执行完后打开mdb,发现数据都没了,只有一个MSyscompactError的表,Errorcode是-1003,无效的参数量,求教错在哪里呀?
以下是代码:
Dim Db As DBEngine
Set Db=New DBEngine
Db.CompactDatabase App.Path & "\Data\Db.mdb",App.Path & "\Tmp.mdb" 执行完后打开mdb,发现数据都没了,只有一个MSyscompactError的表,Errorcode是-1003,无效的参数量,求教错在哪里呀?
set dbe=new DBEngine();
call dbe.CompactDatabase(dbPath, dbPath+".cpt")
'引用Microsoft Jet and Replication Objects 2.X library
Dim jro As jro.JetEngine
Set jro = New jro.JetEngine
jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\test\test.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\test\new.mdb;"
'Jet OLEDB:Engine Type=4