1 //DB最適化処理
2 JRO.JetEngine jroJet = new JRO.JetEngine();
3 jroJet.CompactDatabase(
4 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\mdb1.mdb;User ID=Admin;Jet OLEDB:Database Password=xxxx",
5 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\mdb2.mdb;User ID=Admin;Jet OLEDB:Database Password=xxxx");
6
7 File.Delete(C:\Program Files\mdb1.mdb);
8
9 jroJet.CompactDatabase(
10 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\mdb2.mdb;User ID=Admin;Jet OLEDB:Database Password=xxxx",
11 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\mdb1.mdb;User ID=Admin;Jet OLEDB:Database Password=xxxx");
12
13 File.Delete(C:\Program Files\mdb2.mdb);
|