Access中!如何使用命令行/compact压缩带密码的数据库!!!!

[nyucv]

如题!!!!

[lijipan]

public static void CompactAccessDB(string connectionString, string mdwfilename)
{
object[] oParams;

object objJRO =
Activator.CreateInstance(Type.GetTypeFromProgID("JRO.JetEngine"));

oParams = new object[] {
connectionString,
"Provider=Microsoft.Jet.OLEDB.4.0;Data" +
" Source=C:\\tempdb.mdb;Jet OLEDB:Engine Type=5"};

objJRO.GetType().InvokeMember("CompactDatabase",
System.Reflection.BindingFlags.InvokeMethod,
null,
objJRO,
oParams);

System.IO.File.Delete(mdwfilename);
System.IO.File.Move("C:\\tempdb.mdb", mdwfilename);

System.Runtime.InteropServices.Marshal.ReleaseComObject(objJRO);
objJRO=null;
}

[9sun888]

http://community.csdn.net/Expert/topic/4092/4092399.xml?temp=.7451898