{"id":998,"date":"2020-02-04T16:23:50","date_gmt":"2020-02-04T21:23:50","guid":{"rendered":"https:\/\/www.baronsoftware.com\/Blog\/?p=998"},"modified":"2020-02-04T16:24:51","modified_gmt":"2020-02-04T21:24:51","slug":"using-delphi-firedac-to-compact-and-repair-a-ms-access-database","status":"publish","type":"post","link":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/","title":{"rendered":"Using Delphi Firedac to compact and repair a MS Access Database."},"content":{"rendered":"\n<p>Over the years Delphi Firedac continues to grow as a robust programming language. Delphi Firedac provides a new way to compact and repair a database. <\/p>\n\n\n\n<p>The tools provide developers with components or services that create superb applications.<\/p>\n\n\n\n<p>Delphi Firedac provides a unique set of Universal Data Access Components for developing multi-device database applications.<\/p>\n\n\n\n<p>This  will show the older method of compacting and repairing MS Access databases.<\/p>\n\n\n\n<p>The code listed below demonstrates the process.  Very straight forward you need to create the object, populate the commands and you are ready to go.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>function CompactAndRepair(DB: string): Boolean;\nvar\n  v: OLEvariant;\nbegin\n  Result := True;\n  try\n    v := CreateOLEObject('JRO.JetEngine');\n    try\n      V.CompactDatabase('Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+DB,\n                        'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+DB+'compacted;Jet OLEDB:Engine Type=5');\n      DeleteFile(DB);\n      RenameFile(DB+'compacted',DB);\n    finally\n      V := Unassigned;\n    end;\n  except\n    Result := False;\n  end;\nend;<\/code><\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"422\" height=\"114\" data-attachment-id=\"950\" data-permalink=\"https:\/\/www.baronsoftware.com\/Blog\/baronsoftwarelogo_2020-fw\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png?fit=422%2C114&amp;ssl=1\" data-orig-size=\"422,114\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"BaronSoftwareLogo_2020.fw\" data-image-description=\"&lt;p&gt;Data Security can no longer be a requirement of the IT Department.  It is vital that the entire company that are within the network be on their utmost watch. The importance today of cyber security cannot be stressed enough.&lt;\/p&gt;\n\" data-image-caption=\"&lt;p&gt;Cyber Security&lt;\/p&gt;\n\" data-large-file=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png?fit=422%2C114&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png?resize=422%2C114&#038;ssl=1\" alt=\"Baron Software\" class=\"wp-image-950\" srcset=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png?w=422&amp;ssl=1 422w, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png?resize=300%2C81&amp;ssl=1 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/figure><\/div>\n\n\n\n<p>Delphi Firedac now has a cleaner way of executing these functions with a few lines.  <\/p>\n\n\n\n<p>In your data module you need to drop a <a rel=\"noreferrer noopener\" aria-label=\"FDMSAccessService component and set the driver link to FDPhysMSAccessDriverLink (opens in a new tab)\" href=\"http:\/\/docwiki.embarcadero.com\/Libraries\/Rio\/en\/FireDAC.Phys.MSAcc.TFDMSAccessService\" target=\"_blank\">FDMSAccessService component and set the driver link to FDPhysMSAccessDriverLink<\/a><\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>The database connection should be close. <\/p>\n\n\n\n<p>The database name and path should be set.<\/p>\n\n\n\n<p>The database password needs to be set only if you use one.<\/p>\n<\/div><\/div>\n\n\n\n<p>Execute a repair and a compact to complete the task.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>function TfrmMainForm.CompactAndRepair(const DB: string): Boolean;\nbegin\n  Result := True;\n  DM.DataMod.FDConnection.Connected := False;\n  DM.DataMod.FDMSAccessService.Database := DB;\n  DM.DataMod.FDMSAccessService.Password := 'PASSWORD';\ntry\n     DM.DataMod.FDMSAccessService.Repair;\n  except\n     on E : Exception do\n     begin\n       ShowMessage('Exception message = '+E.Message);\n       Result := False;\n     end;\n  end;\n\n  try\n      DM.DataMod.FDMSAccessService.Compact;\n  except\n     on E : Exception do\n     begin\n       ShowMessage('Exception message = '+E.Message);\n       Result := False;\n     end;\n  end;\n  DM.DataMod.FDConnection.Connected := True;\n\nend;<\/code><\/pre>\n\n\n\n<p>Using Delphi Firedac makes the process quick and clean.  You can visit the Embarcadero web site for Delphi<a rel=\"noreferrer noopener\" aria-label=\" Firedac database support (opens in a new tab)\" href=\"https:\/\/community.idera.com\/developer-tools\/b\/blog\/posts\/firedac-for-database-access-on-windows-10\" target=\"_blank\"> Firedac database support<\/a>.  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Over the years Delphi Firedac continues to grow as a robust programming language. Delphi Firedac provides a new way to compact and repair a database. The tools provide developers with components or services that create superb applications. Delphi Firedac provides a unique set of Universal Data Access Components for developing multi-device database applications. This will [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":[],"rop_publish_now_history":[],"rop_publish_now_status":"pending","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[102,49,228],"class_list":["post-998","post","type-post","status-publish","format-standard","hentry","category-rad-studio-embarcadero-delphi-development","tag-firedac","tag-microsoft-access","tag-sql-databases"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using Delphi Firedac to compact and repair a MS Access Database. - Baron Software<\/title>\n<meta name=\"description\" content=\"Over the years Delphi continues to grow along with Firedac provides developers with components or services that create superb applications\" \/>\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.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Delphi Firedac to compact and repair a MS Access Database. - Baron Software\" \/>\n<meta property=\"og:description\" content=\"Over the years Delphi continues to grow along with Firedac provides developers with components or services that create superb applications\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Baron Software\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-04T21:23:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-04T21:24:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png\" \/>\n<meta name=\"author\" content=\"richard@baronsoftware.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Using Delphi Firedac to compact and repair a MS Access Database.\" \/>\n<meta name=\"twitter:description\" content=\"Over the years Delphi Firedac continues to grow as a robust programming language. Delphi Firedac provides a new way to compact and repair a database. The tools provide developers with components or services that create superb applications.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo-e1515620410626.jpg?fit=200%2C36&ssl=1\" \/>\n<meta name=\"twitter:creator\" content=\"@Rbaroniunas\" \/>\n<meta name=\"twitter:site\" content=\"@Rbaroniunas\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"richard@baronsoftware.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/\"},\"author\":{\"name\":\"richard@baronsoftware.com\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\"},\"headline\":\"Using Delphi Firedac to compact and repair a MS Access Database.\",\"datePublished\":\"2020-02-04T21:23:50+00:00\",\"dateModified\":\"2020-02-04T21:24:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/\"},\"wordCount\":192,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/BaronSoftwareLogo_2020.fw_.png\",\"keywords\":[\"FireDAC\",\"MIcrosoft Access\",\"SQL Databases\"],\"articleSection\":[\"Rad Studio Delphi Development\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/\",\"name\":\"Using Delphi Firedac to compact and repair a MS Access Database. - Baron Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/BaronSoftwareLogo_2020.fw_.png\",\"datePublished\":\"2020-02-04T21:23:50+00:00\",\"dateModified\":\"2020-02-04T21:24:51+00:00\",\"description\":\"Over the years Delphi continues to grow along with Firedac provides developers with components or services that create superb applications\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/BaronSoftwareLogo_2020.fw_.png?fit=422%2C114&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/BaronSoftwareLogo_2020.fw_.png?fit=422%2C114&ssl=1\",\"width\":422,\"height\":114,\"caption\":\"Cyber Security\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Delphi Firedac to compact and repair a MS Access Database.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#website\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\",\"name\":\"Baron Software\",\"description\":\"Highest Quality Software Developed.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#organization\",\"name\":\"Baron Software\",\"url\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/i2.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i2.wp.com\\\/www.baronsoftware.com\\\/Blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1\",\"width\":1920,\"height\":400,\"caption\":\"Baron Software\"},\"image\":{\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/Rbaroniunas\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.baronsoftware.com\\\/Blog\\\/#\\\/schema\\\/person\\\/079d370e4230be9d5f75885bb33dd8cd\",\"name\":\"richard@baronsoftware.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g\",\"caption\":\"richard@baronsoftware.com\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Delphi Firedac to compact and repair a MS Access Database. - Baron Software","description":"Over the years Delphi continues to grow along with Firedac provides developers with components or services that create superb applications","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.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/","og_locale":"en_US","og_type":"article","og_title":"Using Delphi Firedac to compact and repair a MS Access Database. - Baron Software","og_description":"Over the years Delphi continues to grow along with Firedac provides developers with components or services that create superb applications","og_url":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/","og_site_name":"Baron Software","article_published_time":"2020-02-04T21:23:50+00:00","article_modified_time":"2020-02-04T21:24:51+00:00","og_image":[{"url":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png","type":"","width":"","height":""}],"author":"richard@baronsoftware.com","twitter_card":"summary_large_image","twitter_title":"Using Delphi Firedac to compact and repair a MS Access Database.","twitter_description":"Over the years Delphi Firedac continues to grow as a robust programming language. Delphi Firedac provides a new way to compact and repair a database. The tools provide developers with components or services that create superb applications.","twitter_image":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/logo-e1515620410626.jpg?fit=200%2C36&ssl=1","twitter_creator":"@Rbaroniunas","twitter_site":"@Rbaroniunas","twitter_misc":{"Written by":"richard@baronsoftware.com","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/#article","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/"},"author":{"name":"richard@baronsoftware.com","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd"},"headline":"Using Delphi Firedac to compact and repair a MS Access Database.","datePublished":"2020-02-04T21:23:50+00:00","dateModified":"2020-02-04T21:24:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/"},"wordCount":192,"commentCount":0,"publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png","keywords":["FireDAC","MIcrosoft Access","SQL Databases"],"articleSection":["Rad Studio Delphi Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/","url":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/","name":"Using Delphi Firedac to compact and repair a MS Access Database. - Baron Software","isPartOf":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/#primaryimage"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png","datePublished":"2020-02-04T21:23:50+00:00","dateModified":"2020-02-04T21:24:51+00:00","description":"Over the years Delphi continues to grow along with Firedac provides developers with components or services that create superb applications","breadcrumb":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/#primaryimage","url":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png?fit=422%2C114&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2019\/08\/BaronSoftwareLogo_2020.fw_.png?fit=422%2C114&ssl=1","width":422,"height":114,"caption":"Cyber Security"},{"@type":"BreadcrumbList","@id":"https:\/\/www.baronsoftware.com\/Blog\/using-delphi-firedac-to-compact-and-repair-a-ms-access-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.baronsoftware.com\/Blog\/"},{"@type":"ListItem","position":2,"name":"Using Delphi Firedac to compact and repair a MS Access Database."}]},{"@type":"WebSite","@id":"https:\/\/www.baronsoftware.com\/Blog\/#website","url":"https:\/\/www.baronsoftware.com\/Blog\/","name":"Baron Software","description":"Highest Quality Software Developed.","publisher":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.baronsoftware.com\/Blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.baronsoftware.com\/Blog\/#organization","name":"Baron Software","url":"https:\/\/www.baronsoftware.com\/Blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/logo\/image\/","url":"https:\/\/i2.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2018\/01\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1","contentUrl":"https:\/\/i2.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2018\/01\/BaronSoftwareLogo.fw_.png?fit=1920%2C400&ssl=1","width":1920,"height":400,"caption":"Baron Software"},"image":{"@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/Rbaroniunas"]},{"@type":"Person","@id":"https:\/\/www.baronsoftware.com\/Blog\/#\/schema\/person\/079d370e4230be9d5f75885bb33dd8cd","name":"richard@baronsoftware.com","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e5a3cc457a883c420e8af899f2639359d220ae6bfed4587ca7ed17f45ca0c21c?s=96&d=mm&r=g","caption":"richard@baronsoftware.com"}}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2e6qU-g6","jetpack-related-posts":[{"id":1197,"url":"https:\/\/www.baronsoftware.com\/Blog\/why-choose-delphi-for-rapid-application-development\/","url_meta":{"origin":998,"position":0},"title":"Why Choose Delphi for Rapid Application Development","author":"richard@baronsoftware.com","date":"December 13, 2024","format":false,"excerpt":"Delphi is a rapid application development IDE that shortens time for designing and implementing an application for various platforms. Some of the highlights A visual design interface. Fast compilation speeds Strong database integration. A mature component library (VCL). Its ability to maintain legacy systems. Delphi can create high-performance applications with\u2026","rel":"","context":"In &quot;Rad Studio Delphi Development&quot;","block_context":{"text":"Rad Studio Delphi Development","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/rad-studio-embarcadero-delphi-development\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":487,"url":"https:\/\/www.baronsoftware.com\/Blog\/delphi-developer-days-2017-workshop\/","url_meta":{"origin":998,"position":1},"title":"Delphi Developer Days 2017 Workshop","author":"richard@baronsoftware.com","date":"August 22, 2017","format":false,"excerpt":"Delphi Developer Days 2017 Special Edition Database Workshop \u00a0 Once again the annual Delphi Developer Days are upon us for the year 2017. \u00a0The event will take place in only 3 cities, Chicago, Antwerp and Frankfurt. \u00a0Seats are going fast so to reserve your spot you need to act today.\u2026","rel":"","context":"In &quot;Rad Studio Delphi Development&quot;","block_context":{"text":"Rad Studio Delphi Development","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/rad-studio-embarcadero-delphi-development\/"},"img":{"alt_text":"DDD","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2014\/12\/dddlogo.gif?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":504,"url":"https:\/\/www.baronsoftware.com\/Blog\/expert-delphi-pawel-glowacki\/","url_meta":{"origin":998,"position":2},"title":"Expert Delphi by Pawe\u0142 G\u0142owacki","author":"richard@baronsoftware.com","date":"August 25, 2017","format":false,"excerpt":"Expert Delphi by Pawe\u0142 G\u0142owacki \u00a0 After reading the latest book from Author Pawel Glowacki the feeling of fresh FireMonkey Delphi material left an excellent karma. \u00a0It should be part of anyone's Delphi Library since it has great reference material. \u00a0The book was written by Pawel Glowacki whom is\u00a0Embarcadero's European\u2026","rel":"","context":"In &quot;Book Reviews&quot;","block_context":{"text":"Book Reviews","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/baronsoftware-book-reviews\/"},"img":{"alt_text":"Expert","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2017\/08\/B05667-243x300.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":385,"url":"https:\/\/www.baronsoftware.com\/Blog\/delphi-coming-linux-servers\/","url_meta":{"origin":998,"position":3},"title":"Delphi is coming for Linux Servers","author":"richard@baronsoftware.com","date":"December 16, 2016","format":false,"excerpt":"Delphi is coming for Linux Servers Embarcadero has announced that the next major release for the Delphi language will have Linux server support.\u00a0 What this means to the developers using Delphi is that they can now create service applications for their Linux customers.\u00a0 You have to take into account that\u2026","rel":"","context":"In &quot;Rad Studio Delphi Development&quot;","block_context":{"text":"Rad Studio Delphi Development","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/rad-studio-embarcadero-delphi-development\/"},"img":{"alt_text":"Delphi for Linux","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/12\/LinuxIsComing-300x300.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":342,"url":"https:\/\/www.baronsoftware.com\/Blog\/look-ahead-embarcadero-delphi\/","url_meta":{"origin":998,"position":4},"title":"Look ahead with Embarcadero and Delphi","author":"richard@baronsoftware.com","date":"October 14, 2016","format":false,"excerpt":"Look ahead with Embarcadero and Delphi Embarcadero is hosting a webinar for customers that are on update subscriptions only concerning the next update as well as the anticipated release of\u00a0Godzilla which will contain the\u00a0ability to build Linux server applications with a single code base. \u00a0 Finally Embarcadero is heading in\u2026","rel":"","context":"In &quot;Software Events&quot;","block_context":{"text":"Software Events","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/software-events\/"},"img":{"alt_text":"Look ahead with Delphi","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/EmbarcaderoWeb.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/EmbarcaderoWeb.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/10\/EmbarcaderoWeb.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":249,"url":"https:\/\/www.baronsoftware.com\/Blog\/idera-and-embarcadero-separate-business\/","url_meta":{"origin":998,"position":5},"title":"Idera and Embarcadero separate target businesses","author":"richard@baronsoftware.com","date":"March 8, 2016","format":false,"excerpt":"\u00a0 Idera and Embarcadero separate target businesses \u00a0 Idera and Embarcadero have officially separated their businesses for software development Rad Studio that contains Delphi \/ C++ Builder and the Idera database tools. \u00a0This is a fantastic step in going forward and bringing both web sites with a fresh look on\u2026","rel":"","context":"In &quot;Rad Studio Delphi Development&quot;","block_context":{"text":"Rad Studio Delphi Development","link":"https:\/\/www.baronsoftware.com\/Blog\/category\/rad-studio-embarcadero-delphi-development\/"},"img":{"alt_text":"embarcadero-idera-separate","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2016\/03\/Seattle.jpeg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/comments?post=998"}],"version-history":[{"count":1,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/998\/revisions"}],"predecessor-version":[{"id":999,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/posts\/998\/revisions\/999"}],"wp:attachment":[{"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/media?parent=998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/categories?post=998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baronsoftware.com\/Blog\/wp-json\/wp\/v2\/tags?post=998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}