{"id":1758,"date":"2010-07-18T16:24:39","date_gmt":"2010-07-18T08:24:39","guid":{"rendered":"\/?p=1758"},"modified":"2010-07-18T16:24:39","modified_gmt":"2010-07-18T08:24:39","slug":"1758","status":"publish","type":"post","link":"https:\/\/www.justzz.com\/spec\/1758.html","title":{"rendered":"\u7528C#\u538b\u7f29\u548c\u4fee\u590dAccess\u6570\u636e\u5e93"},"content":{"rendered":"
\n

    \/\/\/ <summary>
    \/\/\/ Access\u6570\u636e\u5e93\u5de5\u5177\u7c7b
    \/\/\/ <\/summary>
    public class AccessDbTool
    {
        \/\/\/ <summary>
        \/\/\/ \u538b\u7f29\u4fee\u590d\u6570\u636e\u5e93\u5de5\u5177
        \/\/\/ \u6ce8\uff1a\u8003\u8651\u5230\u6570\u636e\u5e93\u5df2\u88ab\u6253\u5f00\u7684\u60c5\u51b5\uff0c\u6b64\u5904\u65b9\u6848\u4e3a\u5148COPY\u539f\u6570\u636e\u5e93\uff0c\u518d\u538b\u7f29COPY\u6570\u636e\u5e93\uff0c\u518d\u8986\u76d6\u539f\u6570\u636e\u5e93\uff0c\u518d\u5220\u9664\u4e34\u65f6\u6570\u636e\u5e93
        \/\/\/ <\/summary>
        \/\/\/ <param name=\"path\">\u6570\u636e\u5e93\u7269\u7406\u8def\u5f84<\/param>
        \/\/\/ <param name=\"password\">\u6570\u636e\u5e93\u5bc6\u7801<\/param>
        \/\/\/ <returns><\/returns>
        public static bool compactAccessDB(string path, string password)
        {
            if (path == null || password == null) return false;
            if (path.Equals(\"\")) return false;<\/font><\/p>\n

            string path2 = path.Substring(0, path.LastIndexOf('.')) + \"tmp.mdb\";
            string path3 = path.Substring(0, path.LastIndexOf('.')) + \"copy.mdb\";
            File.Copy(path, path3, true);<\/font><\/p>\n

            string dbConn3, dbConn2;
            dbConn3 = \"Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=\" + password + \";Data Source=\" + path3;
            dbConn2 = \"Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=\" + password + \";Data Source=\" + path2 + \";Jet OLEDB:Engine Type=5\";<\/font><\/p>\n

            try
            {
                JRO.JetEngine dbEngin = new JRO.JetEngine();
                dbEngin.CompactDatabase(dbConn3, dbConn2);\/\/\u538b\u7f29<\/font><\/p>\n

                File.Copy(path2, path, true);\/\/\u5c06\u538b\u7f29\u540e\u7684\u6570\u636e\u5e93\u8986\u76d6\u539f\u6570\u636e\u5e93
                File.Delete(path2);\/\/\u5220\u9664\u538b\u7f29\u540e\u7684\u6570\u636e\u5e93
                File.Delete(path3);\/\/\u5220\u9664\u538b\u7f29\u524d\u7684Copy\u6570\u636e\u5e93<\/font><\/p>\n

                return true;
            }
            catch (Exception e)
            {
                RouseCMS.log.Log.Error(\"AccessDbTool.compactAccessDB\" + \" \" + e.Message);
                RouseCMS.log.Log.Error(e.StackTrace, true);
                return false;
            }
        }
    }<\/font><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    \/\/\/ <summary>    \/\/\/ Access\u6570\u636e\u5e93\u5de5\u5177\u7c7b    \/\/\/ <\/summary>  &…<\/p>\n","protected":false},"author":13,"featured_media":7704,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1758","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-t"],"_links":{"self":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts\/1758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/comments?post=1758"}],"version-history":[{"count":0,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts\/1758\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/media\/7704"}],"wp:attachment":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/media?parent=1758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/categories?post=1758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/tags?post=1758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}