{"id":3682,"date":"2016-09-12T09:44:10","date_gmt":"2016-09-12T09:44:10","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=3682"},"modified":"2025-03-24T10:20:43","modified_gmt":"2025-03-24T10:20:43","slug":"ms-access-database-repair-when-compact-and-repair-not-works","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/","title":{"rendered":"What to do if Compact and Repair is not Working in MS Access?"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>Compact and Repairis a built-in utility in Microsoft Access that you can use to repair a damaged or corrupted Access database file. This utility also helps improve the performance of the database by reducing its size. But sometimes, the Compact and Repair doesn&rsquo;t work and instead causes MS Access to freeze or shows an error message on the screen. At times, the utility fails to repair the database file due to severe corruption or any other reason.&nbsp;In such situations, you need to look for alternate solutions to repair your corrupt or damaged MS Access database file.<\/p><p>If the Compact and Repair utility is not working, you can follow the solutions explained below to repair and recover the corrupt database file.<\/p><h2 class=\"wp-block-heading\" id=\"methods-to-repair-corrupt-access-database-file-when-compact-and-repair-is-not-working\">Methods to Repair Corrupt Access Database File when Compact and Repair is not Working<\/h2><p>If the Compact and Repair utility is not working, you can rename the database file and try to repair it again. You can also try to debug the VBA code as sometimes compilation error or missing reference can prevent the utility from working properly. If these don&rsquo;t work, follow the below methods to repair or <a href=\"https:\/\/www.stellarinfo.com\/blog\/repair-ms-access-database-file-recover-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">recover the corrupted Access database<\/a>.<\/p><h3 class=\"wp-block-heading\">Method 1: Import Database Objects into a New Access Database File<\/h3><p>If the Compact and Repair is not working, you can try to import the objects such as tables, forms, queries, etc., from the corrupted database to a new database file. Follow the below steps to do this:<\/p><ul class=\"wp-block-list\">\n<li>Launch MS Access on your Windows PC.<\/li>\n\n\n\n<li>Select the <strong>Blank desktop database<\/strong> option.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"326\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture1.png\" alt=\"Select the Blank desktop database option\" class=\"wp-image-179484 apply-gradient-on-post-images\" style=\"width:584px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture1.png 487w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture1-300x201.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture1-150x100.png 150w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Provide a name to the new database file and click on <strong>Create<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"371\" height=\"176\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture2.png\" alt=\"Enter name for new database \" class=\"wp-image-179485 apply-gradient-on-post-images\" style=\"width:584px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture2.png 371w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture2-300x142.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture2-150x71.png 150w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>The new database file will open. Click on the <strong>External Data<\/strong> tab in the ribbon and then click on <strong>Access<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"290\" height=\"143\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture3.png\" alt=\"Click on the External Data tab\" class=\"wp-image-179486 apply-gradient-on-post-images\" style=\"width:586px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture3.png 290w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture3-150x74.png 150w\" sizes=\"auto, (max-width: 290px) 100vw, 290px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>The <strong>Get External Data &ndash; Access Database<\/strong> window will open. Click on <strong>Browse<\/strong> against the <strong>File name <\/strong>field to select the problematic Access database file.<\/li>\n\n\n\n<li>Select the <strong>Import tables, queries, etc.<\/strong> radio button and click <strong>OK<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"282\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture4.png\" alt=\"Select the Import tables, queries, etc. radio button\" class=\"wp-image-179487 apply-gradient-on-post-images\" style=\"width:596px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture4.png 377w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture4-300x224.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture4-150x112.png 150w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Next, you will see the <strong>Import Objects<\/strong> window. Click on an object tab and select the required objects under it. You can click on <strong>Select All<\/strong> to select all the objects. Repeat the above steps to select other database objects, like queries, forms, etc. Once you have selected the required objects, click <strong>OK<\/strong> to proceed.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"371\" height=\"359\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture5.png\" alt=\" Import Objects window\" class=\"wp-image-179488 apply-gradient-on-post-images\" style=\"width:582px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture5.png 371w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture5-300x290.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture5-150x145.png 150w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>This will begin the process of importing the selected objects from the corrupted database file into the newly created database file. Once the objects are successfully imported, click <strong>Close<\/strong>.<\/li>\n<\/ul><h3 class=\"wp-block-heading\">Method 2: Use an Access Database Repair Software<\/h3><p>If the Compact and Repair utility is not working, then the best alternative to repair the corrupt Access database file is by using a powerful <a href=\"https:\/\/www.stellarinfo.com\/access-database-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">MS Access database repair tool<\/a>, such as <strong>Stellar Repair for Access<\/strong>. This is an advanced tool that can easily resolve all types of corruption issues in the MS Access database files (ACCDB\/MDB). It can recover all the objects from the corrupted database files with complete integrity and precision.<\/p><p><strong>Here are some benefits of using the Stellar Repair for Access:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Repairs and recovers all Access database objects, such as tables, forms, macros, indexes, linked tables, modules, etc.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.stellarinfo.com\/support\/kb\/index.php\/article\/recover-deleted-records-from-corrupt-ms-access-database\" target=\"_blank\" rel=\"noreferrer noopener\">Recovers deleted table records<\/a><\/li>\n\n\n\n<li>Repairs split database<\/li>\n\n\n\n<li>Recovers non-English data from the problematic database files<\/li>\n\n\n\n<li>Previews the database objects before saving<\/li>\n<\/ul><p><strong>Steps to repair MS Access database file using the software:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Download and install <strong>Stellar Repair for Access<\/strong> on your Windows PC.<\/li>\n\n\n\n<li>Launch the software. You will see the <strong>Select Database<\/strong> window.<\/li>\n\n\n\n<li>Click on <strong>Browse<\/strong> to select the corrupted Access database file.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"328\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture6-1.png\" alt=\"Click on Browse to select the corrupted Access database file\" class=\"wp-image-179491 apply-gradient-on-post-images\" style=\"width:840px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture6-1.png 624w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture6-1-300x158.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture6-1-150x79.png 150w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Once you have selected the file, click on <strong>Repair<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"486\" height=\"382\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture7.png\" alt=\"Cick on Repair\" class=\"wp-image-179493 apply-gradient-on-post-images\" style=\"width:593px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture7.png 486w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture7-300x236.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture7-150x118.png 150w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Once the software successfully repairs the selected database file, it will display all the recoverable objects. You can click on any object to see its preview.<\/li>\n\n\n\n<li>Select the objects you want to recover and click on <strong>Save Database<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"168\" height=\"141\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture8.png\" alt=\"Click on Save Database\" class=\"wp-image-179494 apply-gradient-on-post-images\" style=\"width:362px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture8.png 168w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/Picture8-150x126.png 150w\" sizes=\"auto, (max-width: 168px) 100vw, 168px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Now, select a location to save the repaired database file and click <strong>OK<\/strong>.<\/li>\n<\/ul><p>The repaired file will be saved at the selected location. You can go to the location to check the repaired database file.<\/p><h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2><p>If the Compact and Repair tool in MS Access is not working, you can try to export the problematic database file objects to a new file as discussed above. However, the best option is to use a powerful Access database repair software, like <strong>Stellar Repair for Access<\/strong>. The software can help you repair the corrupt or damaged MS Access database file and recover all the objects such as forms, tables, queries, etc., in a quick and simple way.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Compact and Repairis a built-in utility in Microsoft Access that you can&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/\">Continue reading <span class=\"screen-reader-text\">What to do if Compact and Repair is not Working in MS Access?<\/span><\/a><\/p>\n","protected":false},"author":83,"featured_media":42989,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[824],"tags":[1198,1199,1200,336],"class_list":["post-3682","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-access-database","tag-access-database-compact-and-repair-not-working","tag-access-database-repair-fails","tag-compact-and-repair-fails-access-database-2016","tag-ms-access-2016-repair","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What to do if Compact and Repair is not working in MS Access?<\/title>\n<meta name=\"description\" content=\"Fix corrupt Access database by importing database objects to new database file or using an advanced access database repair tool. Restore your data with ease!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What to do if Compact and Repair is not working in MS Access?\" \/>\n<meta property=\"og:description\" content=\"Fix corrupt Access database by importing database objects to new database file or using an advanced access database repair tool. Restore your data with ease!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-12T09:44:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-24T10:20:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Keshav Katyal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keshav Katyal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/\"},\"author\":{\"name\":\"Keshav Katyal\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/091631adbcb67b5a279c9c5a152a4e27\"},\"headline\":\"What to do if Compact and Repair is not Working in MS Access?\",\"datePublished\":\"2016-09-12T09:44:10+00:00\",\"dateModified\":\"2025-03-24T10:20:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/\"},\"wordCount\":753,\"commentCount\":11,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg\",\"keywords\":[\"Access Database Compact and Repair not working\",\"Access Database Repair fails\",\"Compact and Repair fails Access Database 2016\",\"MS Access 2016 Repair\"],\"articleSection\":[\"Access Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/\",\"name\":\"What to do if Compact and Repair is not working in MS Access?\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg\",\"datePublished\":\"2016-09-12T09:44:10+00:00\",\"dateModified\":\"2025-03-24T10:20:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/091631adbcb67b5a279c9c5a152a4e27\"},\"description\":\"Fix corrupt Access database by importing database objects to new database file or using an advanced access database repair tool. Restore your data with ease!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Repair-Access-2016-Database-when-Compact-and-Repair-not-Working-fails\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What to do if Compact and Repair is not Working in MS Access?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/091631adbcb67b5a279c9c5a152a4e27\",\"name\":\"Keshav Katyal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/123bab8088580836cad4ad66805bea7364f1ea1184799c58204b91281f76b9da?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/123bab8088580836cad4ad66805bea7364f1ea1184799c58204b91281f76b9da?s=96&d=mm&r=g\",\"caption\":\"Keshav Katyal\"},\"description\":\"A passionate writer driven by his interest in everything tech, Keshav Katyal has always been captivated by the latest gadgets since childhood. His interest in technology grew when he got his first gaming console, the Nintendo Game Boy Advanced. Hours and days of tinkering with old &amp; new gadgets made his inner geek passionate about technology.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/cwrtechitauto65789\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/keshav\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What to do if Compact and Repair is not working in MS Access?","description":"Fix corrupt Access database by importing database objects to new database file or using an advanced access database repair tool. Restore your data with ease!","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:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/","og_locale":"en_US","og_type":"article","og_title":"What to do if Compact and Repair is not working in MS Access?","og_description":"Fix corrupt Access database by importing database objects to new database file or using an advanced access database repair tool. Restore your data with ease!","og_url":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2016-09-12T09:44:10+00:00","article_modified_time":"2025-03-24T10:20:43+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg","type":"image\/jpeg"}],"author":"Keshav Katyal","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Keshav Katyal","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/"},"author":{"name":"Keshav Katyal","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/091631adbcb67b5a279c9c5a152a4e27"},"headline":"What to do if Compact and Repair is not Working in MS Access?","datePublished":"2016-09-12T09:44:10+00:00","dateModified":"2025-03-24T10:20:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/"},"wordCount":753,"commentCount":11,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg","keywords":["Access Database Compact and Repair not working","Access Database Repair fails","Compact and Repair fails Access Database 2016","MS Access 2016 Repair"],"articleSection":["Access Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/","url":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/","name":"What to do if Compact and Repair is not working in MS Access?","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg","datePublished":"2016-09-12T09:44:10+00:00","dateModified":"2025-03-24T10:20:43+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/091631adbcb67b5a279c9c5a152a4e27"},"description":"Fix corrupt Access database by importing database objects to new database file or using an advanced access database repair tool. Restore your data with ease!","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-Repair-MS-Access-2016-Database.jpg","width":1000,"height":600,"caption":"Repair-Access-2016-Database-when-Compact-and-Repair-not-Working-fails"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/ms-access-database-repair-when-compact-and-repair-not-works\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What to do if Compact and Repair is not Working in MS Access?"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/091631adbcb67b5a279c9c5a152a4e27","name":"Keshav Katyal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/123bab8088580836cad4ad66805bea7364f1ea1184799c58204b91281f76b9da?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/123bab8088580836cad4ad66805bea7364f1ea1184799c58204b91281f76b9da?s=96&d=mm&r=g","caption":"Keshav Katyal"},"description":"A passionate writer driven by his interest in everything tech, Keshav Katyal has always been captivated by the latest gadgets since childhood. His interest in technology grew when he got his first gaming console, the Nintendo Game Boy Advanced. Hours and days of tinkering with old &amp; new gadgets made his inner geek passionate about technology.","sameAs":["https:\/\/www.linkedin.com\/in\/cwrtechitauto65789\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/keshav\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/3682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=3682"}],"version-history":[{"count":33,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/3682\/revisions"}],"predecessor-version":[{"id":179498,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/3682\/revisions\/179498"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/42989"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=3682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=3682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=3682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}