示例#1
0
        public 存数据库()
        {
            InitializeComponent();
            DatebaseFinished = func_finished;
            Conn             = new OleDbConnection(connstr);
            Conn.Open();
            string       strSql = "DELETE 时间 from Alarm where 时间<#" + DateTime.Now.AddDays(-7) + "#";
            OleDbCommand Cmd    = new OleDbCommand(strSql, Conn);

            Cmd.ExecuteNonQuery();
            Conn.Close();
            DBEngineClass dbengine = new DBEngineClass();

            dbengine.CompactDatabase("F:\\操作日志\\logAccess.mdb", "F:\\操作日志\\myaccess2.mdb");
            File.Delete("F:\\操作日志\\logAccess.mdb");
            File.Move("F:\\操作日志\\myaccess2.mdb", "F:\\操作日志\\logAccess.mdb");
            File.Delete("F:\\操作日志\\myaccess2.mdb");
            Conn.Open();
        }