{"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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">The tools provide developers with components or services that create superb applications.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Delphi Firedac provides a unique set of Universal Data Access Components for developing multi-device database applications.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This  will show the older method of compacting and repairing MS Access databases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">Delphi Firedac now has a cleaner way of executing these functions with a few lines.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">The database connection should be close. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The database name and path should be set.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The database password needs to be set only if you use one.<\/p>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_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},"jetpack_post_was_ever_published":false},"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 v28.4 - 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_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2e6qU-g6","jetpack-related-posts":[{"id":487,"url":"https:\/\/www.baronsoftware.com\/Blog\/delphi-developer-days-2017-workshop\/","url_meta":{"origin":998,"position":0},"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":1},"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":1197,"url":"https:\/\/www.baronsoftware.com\/Blog\/why-choose-delphi-for-rapid-application-development\/","url_meta":{"origin":998,"position":2},"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":130,"url":"https:\/\/www.baronsoftware.com\/Blog\/coderage-x-is-coming-october-13-15-2015\/","url_meta":{"origin":998,"position":3},"title":"CodeRage X is coming October 13-15, 2015","author":"richard@baronsoftware.com","date":"July 30, 2015","format":false,"excerpt":"CodeRage X is coming October 13-15, 2015 Call for papers and pre-registration are open now! Embarcadero Technologies has begun planning for our tenth annual CodeRage online conference. The theme for this year\u2019s CodeRage conference is \u201cDevelop Anything, Anytime, Anywhere.\u201d The CodeRage X Online Developer Conference will take place October 13-15,\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":"CodeRage","src":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2015\/07\/CodeRage.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2015\/07\/CodeRage.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.baronsoftware.com\/Blog\/wp-content\/uploads\/2015\/07\/CodeRage.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":385,"url":"https:\/\/www.baronsoftware.com\/Blog\/delphi-coming-linux-servers\/","url_meta":{"origin":998,"position":4},"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":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":[]}],"jetpack_featured_media_url":"","_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}]}}