{"id":1336,"date":"2019-03-25T17:34:39","date_gmt":"2019-03-25T20:34:39","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb32674-compacting-an-access-database\/"},"modified":"2019-04-22T10:47:17","modified_gmt":"2019-04-22T13:47:17","slug":"kb32674-compacting-an-access-database","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb32674-compacting-an-access-database\/","title":{"rendered":"KB-32674: Compacting an Access database."},"content":{"rendered":"<div style=\"text-align: justify\"><span style=\"font-weight: bold\">Question:<\/span><\/p>\n<p>Why do Access files not reduce their sizes after its records are deleted? Is there another way to make them release this space?<\/p>\n<p><span style=\"font-weight: bold\">Solution:<\/span><\/p>\n<p>This is Access&#8217; normal behavior. When records are deleted, file size remains the same. So, it is necessary to compact the database, which can be done via Access or via scripts.<\/p>\n<p>To compact it via scripts, use the following example:<\/p><\/div>\n<p><span style=\"font-family: Courier New;color: #000000\">Set JRO = CreateObject(&#8220;JRO.JetEngine&#8221;)<\/span><br style=\"font-family: Courier New;color: #000000\" \/><span style=\"font-family: Courier New;color: #000000\">JRO.CompactDatabase &#8220;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dados.mdb&#8221;,_<\/span><br style=\"font-family: Courier New;color: #000000\" \/><span style=\"font-family: Courier New;color: #000000\">&#8220;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dados1.mdb;Jet OLEDB:Engine Type=5&#8221;<\/span><\/p>\n<div style=\"text-align: justify\">This will create another MDB file (which will be compacted), so this compacted file will be recorded over the old one, and then deleted. Attached to this article is an application showing this procedure.<\/p>\n<p><span style=\"font-weight: bold\">Obs.: <\/span>The attached application was develop with E3 version 3.2 build 242.<\/div>\n<div><\/div>\n<h3>Attachments:<\/h3>\n<p><a href=\"\/wp-content\/uploads\/2019\/03\/CompactarAccess-1.zip\">CompactarAccess<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Question: Why do Access files not reduce their sizes after its records are deleted? Is there another way to make them release this space? Solution: This is Access&#8217; normal behavior.&hellip;<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[735,763],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-32674: Compacting an Access database. - Elipse Knowledgebase<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-32674: Compacting an Access database.\" \/>\n<meta property=\"og:description\" content=\"Question: Why do Access files not reduce their sizes after its records are deleted? Is there another way to make them release this space? Solution: This is Access&#8217; normal behavior.&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:34:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-22T13:47:17+00:00\" \/>\n<meta name=\"author\" content=\"Renan De Rossi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Renan De Rossi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/\"},\"author\":{\"name\":\"Renan De Rossi\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/05f0d8f49e5ffe573156b4bd742c627f\"},\"headline\":\"KB-32674: Compacting an Access database.\",\"datePublished\":\"2019-03-25T20:34:39+00:00\",\"dateModified\":\"2019-04-22T13:47:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/\"},\"wordCount\":145,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\",\"Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/\",\"url\":\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/\",\"name\":\"[:pt]KB-32674: Compacting an Access database.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:34:39+00:00\",\"dateModified\":\"2019-04-22T13:47:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-32674: Compacting an Access database.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/05f0d8f49e5ffe573156b4bd742c627f\",\"name\":\"Renan De Rossi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/39b08f7b309bb6a0abb90e1f09048d80?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/39b08f7b309bb6a0abb90e1f09048d80?s=96&d=mm&r=g\",\"caption\":\"Renan De Rossi\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/renan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-32674: Compacting an Access database. - Elipse Knowledgebase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-32674: Compacting an Access database.[:] - Elipse Knowledgebase","og_description":"Question: Why do Access files not reduce their sizes after its records are deleted? Is there another way to make them release this space? Solution: This is Access&#8217; normal behavior.&hellip;","og_url":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:34:39+00:00","article_modified_time":"2019-04-22T13:47:17+00:00","author":"Renan De Rossi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Renan De Rossi","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/"},"author":{"name":"Renan De Rossi","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/05f0d8f49e5ffe573156b4bd742c627f"},"headline":"KB-32674: Compacting an Access database.","datePublished":"2019-03-25T20:34:39+00:00","dateModified":"2019-04-22T13:47:17+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/"},"wordCount":145,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases","Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/","url":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/","name":"[:pt]KB-32674: Compacting an Access database.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:34:39+00:00","dateModified":"2019-04-22T13:47:17+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/kb32674-compacting-an-access-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-32674: Compacting an Access database."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/05f0d8f49e5ffe573156b4bd742c627f","name":"Renan De Rossi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/39b08f7b309bb6a0abb90e1f09048d80?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/39b08f7b309bb6a0abb90e1f09048d80?s=96&d=mm&r=g","caption":"Renan De Rossi"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/renan\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1336"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=1336"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1336\/revisions"}],"predecessor-version":[{"id":4233,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1336\/revisions\/4233"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=1336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=1336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=1336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}