{"id":95920,"date":"2022-03-16T11:06:02","date_gmt":"2022-03-16T11:06:02","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=95920"},"modified":"2026-03-02T08:43:26","modified_gmt":"2026-03-02T08:43:26","slug":"compact-and-repair-access-database-using-vb-net","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/","title":{"rendered":"How to Compact and Repair Access Database Using VB.NET?"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>An Access database file increases in size with the continuous addition of data. Also, the database file can grow in size in any of these situations:<\/p><ul class=\"wp-block-list\">\n<li>MS Access creates temporary objects (that are hidden) for performing several tasks. For instance, Access may create objects to query external sources when used as a back-end. Even though they are no longer needed, these objects remain in the database.<\/li>\n\n\n\n<li>When a database object is deleted, the disk space consumed by that object remains empty and is not reclaimed. And, more space on the disk is occupied for a new object.<\/li>\n<\/ul><p>The large size of the file increases risk of database corruption. The corruption risk is higher when users frequently edit the MEMO fields in a Visual Basic for Applications (VBA) module. To prevent corruption and other issues, you can reduce the Access database file size by compacting and repairing the database.<\/p><h2 class=\"wp-block-heading\" id=\"why-compact-and-repair?\">Why Compact and Repair?<\/h2><p><strong>Running the Compact and Repair utility helps:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Reorganize indexes for increasing database efficiency.<\/li>\n\n\n\n<li>Reclaim empty space from deleted records or objects.<\/li>\n\n\n\n<li>Lower the risk of corruption of a split database.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"how-to-compact-and-repair-access-database-using-vb.net?\">How to Compact and Repair Access Database Using VB.NET?<\/h2><p>You can schedule to compact and repair an Access database through code in VB.NET. However, you must have exclusive access to the database before compacting and repairing it. The detailed steps are as follows:<\/p><ul class=\"wp-block-list\">\n<li>Add a reference to &ldquo;Microsoft Jet and Replication Objects 2.6 Library&rdquo;.<\/li>\n\n\n\n<li>Copy and paste the following code to display a warning message if the database is in use.<\/li>\n<\/ul><div class=\"wp-block-group is-style-twentytwentyone-border has-black-color has-text-color\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-group is-style-twentytwentyone-border\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Dim strAccessDBPath As String =&rdquo;ENTER PATH OF YOUR ACCESS DB&rdquo;<br>Dim LockedDbFileInfo As New System.IO.FileInfo(strAccessDBPath.Replace(&ldquo;.accdb&rdquo;, &ldquo;.laccdb&rdquo;))<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If LockedDbFileInfo.Exists Then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lsquo;Give warning that the database is in use.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div>\n<\/div><\/div><ul class=\"wp-block-list\">\n<li>Create a temporary folder, like TempFolder, and then copy the database using the below query:<\/li>\n<\/ul><div class=\"wp-block-group is-style-twentytwentyone-border\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Rename(strAccessDBPath, TempFolder.FullName &amp; &ldquo;\\&rdquo; &amp; &ldquo;db1.accdb&rdquo;)<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div><ul class=\"wp-block-list\">\n<li>Create a JRO JetEngine object and compact the database (i.e., db1 in our case) by calling the compact method. Next, replace the original database with the compacted one. Once the compacting operation is complete, delete the temp folder.<\/li>\n<\/ul><div class=\"wp-block-group is-style-twentytwentyone-border has-link-color wp-elements-28b97fe199bad84bb0d9b6a70a156718\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Dim JRO As New JRO.JetEngine<br>JRO.CompactDatabase(&ldquo;Provider=Microsoft.Jet.OLEDB.4.0;&rdquo; &amp; &ldquo;Data Source= &rdquo; &amp; TempFolder.FullName &amp; &ldquo;\\&rdquo; &amp; &ldquo;db1.accdb&rdquo;, _<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &ldquo;Provider=Microsoft.Jet.OLEDB.4.0;&rdquo; &amp; &ldquo;Data Source=&rdquo; &amp; strAccessDBPath &amp; &ldquo;;Jet OLEDB:Engine Type=5&rdquo;)<br>TempFolder.Delete(True)<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div><h2 class=\"wp-block-heading\" id=\"what-if-the-access-database-gets-corrupted?\">What If the Access Database gets Corrupted?<\/h2><p>You can run the Compact and Repair tool to fix a corrupted Access database. If the utility fails to repair the database, you can use an advanced <a href=\"https:\/\/www.stellarinfo.com\/access-database-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">Access database repair tool<\/a>, such as Stellar Repair for Access. The software can help you fix corruption in damaged or corrupted .accdb and .mdb database files. Also, it helps repair tables, modules, macros, and other objects of the database. It even allows repairing a corrupted split Access database and linked tables. The software also previews all the recoverable objects extracted from the corrupt file, including tables, linked tables, queries, etc. &nbsp;<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/cloud.stellarinfo.com\/StellarRepairforAccess-B.exe\"><img loading=\"lazy\" decoding=\"async\" width=\"226\" height=\"62\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Microsoft-vs-bing-1.png\" alt=\"Free Download for Windows\" class=\"wp-image-166355 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Microsoft-vs-bing-1.png 226w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Microsoft-vs-bing-1-150x41.png 150w\" sizes=\"auto, (max-width: 226px) 100vw, 226px\" \/><\/a><\/figure>\n<\/div><h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2><p>The size of an Access database can increase rapidly due to the accumulation of temporary database objects that are no longer required. Also, the database size can grow when the disk space occupied by an object is not reclaimed. Furthermore, the large database file size makes it vulnerable to corruption. And so, compacting and repairing the database is crucial to reduce the size of the database file. This blog explained the steps to compact and repair an Access DB through code in VB.NET. The code helps schedule running the <a href=\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-without-opening\/\" target=\"_blank\" rel=\"noreferrer noopener\">Compact and Repair utility<\/a>.<\/p><p>If the Access database has turned corrupt due to its large size, use Stellar Repair for Access to repair the corrupted DB and restore all its components.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An Access database file increases in size with the continuous addition of&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/\">Continue reading <span class=\"screen-reader-text\">How to Compact and Repair Access Database Using VB.NET?<\/span><\/a><\/p>\n","protected":false},"author":34,"featured_media":95924,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[824],"tags":[1198,411],"class_list":["post-95920","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","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Compact and Repair Access Database Using VB.NET Code<\/title>\n<meta name=\"description\" content=\"Learn how to compact and repair an Access database using VB.NET code. Discover why compacting matters, step-by-step code walkthrough &amp; how to fix DB corruption.\" \/>\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\/compact-and-repair-access-database-using-vb-net\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Compact and Repair Access Database Using VB.NET Code\" \/>\n<meta property=\"og:description\" content=\"Learn how to compact and repair an Access database using VB.NET code. Discover why compacting matters, step-by-step code walkthrough &amp; how to fix DB corruption.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-16T11:06:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-02T08:43:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.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=\"Charanjeet Kaur\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Charanjeet Kaur\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/\"},\"author\":{\"name\":\"Charanjeet Kaur\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/4bcf0d3fb4f61fce73560518655de4f2\"},\"headline\":\"How to Compact and Repair Access Database Using VB.NET?\",\"datePublished\":\"2022-03-16T11:06:02+00:00\",\"dateModified\":\"2026-03-02T08:43:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/\"},\"wordCount\":663,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg\",\"keywords\":[\"Access Database Compact and Repair not working\",\"Access Database Repair\"],\"articleSection\":[\"Access Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/\",\"name\":\"How to Compact and Repair Access Database Using VB.NET Code\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg\",\"datePublished\":\"2022-03-16T11:06:02+00:00\",\"dateModified\":\"2026-03-02T08:43:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/4bcf0d3fb4f61fce73560518655de4f2\"},\"description\":\"Learn how to compact and repair an Access database using VB.NET code. Discover why compacting matters, step-by-step code walkthrough & how to fix DB corruption.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg\",\"width\":1000,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Compact and Repair Access Database Using VB.NET?\"}]},{\"@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\/4bcf0d3fb4f61fce73560518655de4f2\",\"name\":\"Charanjeet Kaur\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4660bcceddd78a5c4de4caf8ed709c17893427075cd639070c6dc090adc520f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4660bcceddd78a5c4de4caf8ed709c17893427075cd639070c6dc090adc520f?s=96&d=mm&r=g\",\"caption\":\"Charanjeet Kaur\"},\"description\":\"Charanjeet is a Technical Content Writer at Stellar\u00aewho specializes in writing about databases, e-mail recovery, and e-mail migration solutions. She loves researching and developing content that helps database administrators, organizations and novices to fix multiple problems related to MS SQL and MySQL databases and Microsoft Exchange.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/charanjeet-kaur-1b791920\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/charanjeet\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Compact and Repair Access Database Using VB.NET Code","description":"Learn how to compact and repair an Access database using VB.NET code. Discover why compacting matters, step-by-step code walkthrough & how to fix DB corruption.","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\/compact-and-repair-access-database-using-vb-net\/","og_locale":"en_US","og_type":"article","og_title":"How to Compact and Repair Access Database Using VB.NET Code","og_description":"Learn how to compact and repair an Access database using VB.NET code. Discover why compacting matters, step-by-step code walkthrough & how to fix DB corruption.","og_url":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2022-03-16T11:06:02+00:00","article_modified_time":"2026-03-02T08:43:26+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg","type":"image\/jpeg"}],"author":"Charanjeet Kaur","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Charanjeet Kaur","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/"},"author":{"name":"Charanjeet Kaur","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/4bcf0d3fb4f61fce73560518655de4f2"},"headline":"How to Compact and Repair Access Database Using VB.NET?","datePublished":"2022-03-16T11:06:02+00:00","dateModified":"2026-03-02T08:43:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/"},"wordCount":663,"commentCount":0,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg","keywords":["Access Database Compact and Repair not working","Access Database Repair"],"articleSection":["Access Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/","url":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/","name":"How to Compact and Repair Access Database Using VB.NET Code","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg","datePublished":"2022-03-16T11:06:02+00:00","dateModified":"2026-03-02T08:43:26+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/4bcf0d3fb4f61fce73560518655de4f2"},"description":"Learn how to compact and repair an Access database using VB.NET code. Discover why compacting matters, step-by-step code walkthrough & how to fix DB corruption.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2022\/03\/compact-and-repair-access-database-using-vbnet.jpg","width":1000,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/compact-and-repair-access-database-using-vb-net\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Compact and Repair Access Database Using VB.NET?"}]},{"@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\/4bcf0d3fb4f61fce73560518655de4f2","name":"Charanjeet Kaur","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4660bcceddd78a5c4de4caf8ed709c17893427075cd639070c6dc090adc520f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4660bcceddd78a5c4de4caf8ed709c17893427075cd639070c6dc090adc520f?s=96&d=mm&r=g","caption":"Charanjeet Kaur"},"description":"Charanjeet is a Technical Content Writer at Stellar\u00aewho specializes in writing about databases, e-mail recovery, and e-mail migration solutions. She loves researching and developing content that helps database administrators, organizations and novices to fix multiple problems related to MS SQL and MySQL databases and Microsoft Exchange.","sameAs":["https:\/\/www.linkedin.com\/in\/charanjeet-kaur-1b791920\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/charanjeet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/95920","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\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=95920"}],"version-history":[{"count":14,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/95920\/revisions"}],"predecessor-version":[{"id":190597,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/95920\/revisions\/190597"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/95924"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=95920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=95920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=95920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}