{"id":142532,"date":"2023-07-18T10:32:32","date_gmt":"2023-07-18T10:32:32","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=142532"},"modified":"2026-03-30T06:22:16","modified_gmt":"2026-03-30T06:22:16","slug":"resolve-access-error-3047-record-is-too-large","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/","title":{"rendered":"Ways to Resolve MS Access Error 3047: Record is Too Large"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>You can get the error 3047: Record is a too large while importing\/exporting data in Access or when adding or editing the records. It usually appears if the size of the records exceeds the maximum size limit allowed by MS Access. This error may prevent you from modifying the records or exporting the data to an external file.<\/p><h2 class=\"wp-block-heading\" id=\"what-causes-access-error-3047:-record-is-too-large?\"><strong>What Causes Access Error 3047: Record is Too Large?<\/strong><\/h2><p><strong>There are different reasons that can lead to the Access error 3047. Some of them are:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Memo field (Long Text) size limit<\/li>\n\n\n\n<li>Large attachments<\/li>\n\n\n\n<li>Fields in the table exceeded the maximum limit of the file<\/li>\n\n\n\n<li>Importing a large dataset beyond the import size limitations<\/li>\n\n\n\n<li>The database contains duplicate data<\/li>\n\n\n\n<li>Database is corrupted<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"resolve-access-error-3047:-record-is-too-large\"><strong>Resolve Access Error 3047: Record is too Large<\/strong><\/h2><p>First, check and remove the unnecessary attachments in the records in the database. It may help you reduce the overall Access file size. If it doesn&rsquo;t fix the issue, try the below methods:<\/p><h3 class=\"wp-block-heading\" id=\"h-method-1-check-the-field-size-issue\">Method 1: Check and Fix the Field Size Issue<\/h3><p>The number of fields in a recordset should be up to 255 and the record set size should not be more than 1 gigabyte. If the Access file&rsquo;s data exceeds the designated size limit, then you can get the Record is too large error. You can check the field size using the below steps:&nbsp;<\/p><ul class=\"wp-block-list\">\n<li>In the <strong>Navigation <\/strong>pane, right-click on the desired field of the table that you need to change.<\/li>\n\n\n\n<li>Click <strong>Design View<\/strong>.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"245\" height=\"385\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-design-view.jpg\" alt=\"Click Design View\" class=\"wp-image-142536 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-design-view.jpg 245w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-design-view-191x300.jpg 191w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-design-view-150x236.jpg 150w\" sizes=\"auto, (max-width: 245px) 100vw, 245px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>In the design grid of the table, right-click on the field that you need to check and select <strong>Properties<\/strong>.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"135\" height=\"184\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-properties-option.jpg\" alt=\"Click Properties Option\" class=\"wp-image-142556 apply-gradient-on-post-images\"><\/figure><ul class=\"wp-block-list\">\n<li>In the <strong>Field Properties<\/strong>, check the <strong>Field Size<\/strong> option under the <strong>General <\/strong>section.&nbsp;<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"236\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-field-properties-in-general.jpg\" alt=\"Click Field Properties In General\" class=\"wp-image-142557 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-field-properties-in-general.jpg 458w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-field-properties-in-general-300x155.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-field-properties-in-general-150x77.jpg 150w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/figure><p>The field size value should be between 1 and 255. If the size value is more than 255, then convert the field to&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/the-memo-data-type-is-now-called-long-text-dffe5e34-953e-4451-a05e-fba5d9b564b5\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Memo Field\/Long Text<\/a>. Converting a field to a memo data type can help increase the storage capacity of that field.<\/p><p><strong>Here are the steps to convert the field&rsquo;s data type:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>In the <strong>Navigation <\/strong>pane, double-click on the desired table.<\/li>\n\n\n\n<li>Click on the field that you need to change.<\/li>\n\n\n\n<li>Click <strong>Fields<\/strong>. In the <strong>Properties <\/strong>group, click on the arrow in the dropdown list.<\/li>\n\n\n\n<li>Select <strong>Long Text<\/strong> and then save the applied changes.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"161\" height=\"286\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/select-long-text-option.jpg\" alt=\"Select Long Text Option\" class=\"wp-image-142547 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/select-long-text-option.jpg 161w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/select-long-text-option-150x266.jpg 150w\" sizes=\"auto, (max-width: 161px) 100vw, 161px\" \/><\/figure><h3 class=\"wp-block-heading\" id=\"h-method-2-use-docmd-transferspreadsheet-method\">Method 2: Use the DoCmd.TransferSpreadsheet Method<\/h3><p>You can have a maximum of 2 GB database file with a maximum of 4000 records. If the records you&rsquo;re working with exceed the maximum record size limit, then you can get the error 3047. To fix this, you can create an Excel workbook and use a linked table. Create a query in Access (with a linked table representing that Excel file) and use the TransferSpreadsheet method to export to Excel.<\/p><h3 class=\"wp-block-heading\" id=\"h-method-3-use-docmd-output-to-method\">Method 3: Use the DoCmd.OutputTo Method for Exporting<\/h3><p>You can encounter the error 3047: The record is too large while exporting the query to another application. Try the&nbsp;<a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/access.docmd.outputto\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">DoCmd.Output To method<\/a>&nbsp;in VBA to export Access query of more than 4000 records. Using this method, you can specify the output format to help you control the data you are trying to export. For more accuracy, you can export the query to XLS format.<\/p><h3 class=\"wp-block-heading\" id=\"h-method-4-split-the-database\">Method 4: Split the Database to Reduce File Size<\/h3><p>You can also split the database in Microsoft Access to resolve the size limit issue.&nbsp;<a href=\"https:\/\/www.stellarinfo.com\/blog\/split-access-database\/\" target=\"_blank\" rel=\"noreferrer noopener\">Splitting the database<\/a>&nbsp;segregates the data into two files, i.e., the back-end and front-end. The back-end database file contains the data tables and table links, whereas the front-end database contains data objects, such as forms, reports, and queries. It helps in reducing the overall size of the database file.<\/p><h3 class=\"wp-block-heading\" id=\"h-method-5-normalize-the-table-in-the-database\">Method 5: Normalize the Table to Remove Data Redundancy<\/h3><p>The Access error 3047: Record is too large occurs due to large size of the records in the database. If you are getting this error while importing\/exporting data between Access and other applications, then you can normalize the table. Normalizing the table in database helps in organizing data into multiple-related tables and eliminates data redundancy which eventually helps in reducing the record size. To do this, you can use the Access <strong>Table Analyzer<\/strong>. Here are the steps:<\/p><ul class=\"wp-block-list\">\n<li>Go to <strong>Database Tools<\/strong> and click <strong>Analyze Table<\/strong>.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"718\" height=\"150\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-database-tools-to-select-analyze-table.jpg\" alt=\"Click Database Tools To Select Analyze Table\" class=\"wp-image-142554 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-database-tools-to-select-analyze-table.jpg 718w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-database-tools-to-select-analyze-table-300x63.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-database-tools-to-select-analyze-table-150x31.jpg 150w\" sizes=\"auto, (max-width: 718px) 100vw, 718px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>The <strong>Table Analyzer Wizard<\/strong> will display all fields in the table with repeated information. In the below image, you can see that the supplier information is repeated.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"579\" height=\"442\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Table-Analyzer-wizard-window-2.jpg\" alt=\"Table Analyzer Wizard Window\" class=\"wp-image-142553 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Table-Analyzer-wizard-window-2.jpg 579w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Table-Analyzer-wizard-window-2-300x229.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Table-Analyzer-wizard-window-2-150x115.jpg 150w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Click on the <strong>Next<\/strong> option to split the table into two or more related tables.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"578\" height=\"442\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-on-next-option-1.jpg\" alt=\"Click On Next Option\" class=\"wp-image-142555 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-on-next-option-1.jpg 578w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-on-next-option-1-300x229.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-on-next-option-1-150x115.jpg 150w\" sizes=\"auto, (max-width: 578px) 100vw, 578px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Click <strong>Next.<\/strong><\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"579\" height=\"442\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-next-option-1.jpg\" alt=\"Click Next Option\" class=\"wp-image-142558 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-next-option-1.jpg 579w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-next-option-1-300x229.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-next-option-1-150x115.jpg 150w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Click <strong>Next<\/strong> and follow the on-screen instructions.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"578\" height=\"442\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-on-next-option-2.jpg\" alt=\"Click On Next Option\" class=\"wp-image-142559 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-on-next-option-2.jpg 578w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-on-next-option-2-300x229.jpg 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/click-on-next-option-2-150x115.jpg 150w\" sizes=\"auto, (max-width: 578px) 100vw, 578px\" \/><\/figure><p>The Table Analyzer divides the table with repeated fields into separate tables. This will reduce the database size and make it more efficient.<\/p><h3 class=\"wp-block-heading\" id=\"h-method-6-repair-the-database\">Method 6: Repair the Corrupted Access Database<\/h3><p>Sometimes, the MS Access error 3047 can occur due to corruption in the database. The corrupted database can create inconsistent records, leading to the Record is too large error. You can use the Compact and Repair utility in Access to optimize the database file, reduce its overall size, and repair it. <strong>Here are the steps<\/strong>:<\/p><ul class=\"wp-block-list\">\n<li>Open the Access application.<\/li>\n\n\n\n<li>Go to <strong>File &gt; Info &gt; Compact &amp; Repair Database<\/strong>.<\/li>\n<\/ul><p>Access creates a copy of the compacted and repaired database file at the same location where the original database is stored.<\/p><p>If the Compact and Repair tool fails to fix the issue, then you can opt for an advanced Access repair software, such as <a href=\"https:\/\/www.stellarinfo.com\/access-database-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">Stellar Repair for Access<\/a>. This Access repair software helps in fixing the corrupted .MDB\/.ACCDB files and recovering all the objects, like tables, records, reports, queries, etc. The software can handle all types of corruption-related errors, including the Access error 3047: The record is too large.<\/p><h2 class=\"wp-block-heading\" id=\"when-compact-and-repair-is-not-enough\"><strong>When Compact and Repair Is Not Enough<\/strong><\/h2><p>The Access error 3047: Record is too large can usually occur while exporting data from Access or when trying to modify records that exceed the permitted limit. This error is related to the size of the records you are trying to export or modify. You can try the methods discussed above to resolve the error. If nothing works, then use Stellar Repair for Access &ndash; an advanced Access repair software that can repair Access database files with 100% integrity. It can recover all the data from the corrupted database. The tool is compatible with all Windows operating systems, including Windows 11. You can download the software&rsquo;s demo version to evaluate its functionality.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can get the error 3047: Record is a too large while&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/\">Continue reading <span class=\"screen-reader-text\">Ways to Resolve MS Access Error 3047: Record is Too Large<\/span><\/a><\/p>\n","protected":false},"author":82,"featured_media":142561,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[824],"tags":[],"class_list":["post-142532","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-access-database","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fix MS Access Error 3047: Record is Too Large [6 Methods]<\/title>\n<meta name=\"description\" content=\"Getting Access error 3047 &quot;Record is too large&quot;? Here are 6 ways to fix it, from checking field size to repairing a corrupted database.\" \/>\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\/resolve-access-error-3047-record-is-too-large\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fix MS Access Error 3047: Record is Too Large [6 Methods]\" \/>\n<meta property=\"og:description\" content=\"Getting Access error 3047 &quot;Record is too large&quot;? Here are 6 ways to fix it, from checking field size to repairing a corrupted database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T10:32:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-30T06:22:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.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=\"Monika Dadool\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Monika Dadool\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/\"},\"author\":{\"name\":\"Monika Dadool\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd\"},\"headline\":\"Ways to Resolve MS Access Error 3047: Record is Too Large\",\"datePublished\":\"2023-07-18T10:32:32+00:00\",\"dateModified\":\"2026-03-30T06:22:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/\"},\"wordCount\":1049,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg\",\"articleSection\":[\"Access Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/\",\"name\":\"Fix MS Access Error 3047: Record is Too Large [6 Methods]\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg\",\"datePublished\":\"2023-07-18T10:32:32+00:00\",\"dateModified\":\"2026-03-30T06:22:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd\"},\"description\":\"Getting Access error 3047 \\\"Record is too large\\\"? Here are 6 ways to fix it, from checking field size to repairing a corrupted database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Ways To Resolve Access Error 3047 Record Is Too Large\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ways to Resolve MS Access Error 3047: Record is Too Large\"}]},{\"@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\/02a465e9b5b4912eafedd1ae248558fd\",\"name\":\"Monika Dadool\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g\",\"caption\":\"Monika Dadool\"},\"description\":\"Monika Dadool is a Senior Content Writer at Stellar with over 5 years of experience in technical writing. She is a tech enthusiast and expert who specializes in writing about SQL Server, MySQL Server, MariaDB Server, Microsoft Access, Active Directory, email recovery, Microsoft 365, pattern recognition, machine learning, data recovery, file repair, and operating systems like Linux, Windows, and Mac. She also writes about accounting software such as QuickBooks and Sage 50, as well as web-scripting languages like HTML, JavaScript, Python, PHP, Visual Basic, ASP.NET, and AJAX. Monika is passionate about researching and exploring new technologies, and she enjoys developing engaging technical blogs that help organizations and database administrators resolve various issues. When she's not creating content, you can find her on social media, watching web series, reading books, or exploring new food recipes.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/monika-dadool-105a87163\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/monika\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fix MS Access Error 3047: Record is Too Large [6 Methods]","description":"Getting Access error 3047 \"Record is too large\"? Here are 6 ways to fix it, from checking field size to repairing a corrupted database.","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\/resolve-access-error-3047-record-is-too-large\/","og_locale":"en_US","og_type":"article","og_title":"Fix MS Access Error 3047: Record is Too Large [6 Methods]","og_description":"Getting Access error 3047 \"Record is too large\"? Here are 6 ways to fix it, from checking field size to repairing a corrupted database.","og_url":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2023-07-18T10:32:32+00:00","article_modified_time":"2026-03-30T06:22:16+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg","type":"image\/jpeg"}],"author":"Monika Dadool","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Monika Dadool","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/"},"author":{"name":"Monika Dadool","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd"},"headline":"Ways to Resolve MS Access Error 3047: Record is Too Large","datePublished":"2023-07-18T10:32:32+00:00","dateModified":"2026-03-30T06:22:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/"},"wordCount":1049,"commentCount":0,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg","articleSection":["Access Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/","url":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/","name":"Fix MS Access Error 3047: Record is Too Large [6 Methods]","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg","datePublished":"2023-07-18T10:32:32+00:00","dateModified":"2026-03-30T06:22:16+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd"},"description":"Getting Access error 3047 \"Record is too large\"? Here are 6 ways to fix it, from checking field size to repairing a corrupted database.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/07\/Ways-To-Resolve-Access-Error-3047-Record-Is-Too-Large.jpg","width":1000,"height":600,"caption":"Ways To Resolve Access Error 3047 Record Is Too Large"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/resolve-access-error-3047-record-is-too-large\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Ways to Resolve MS Access Error 3047: Record is Too Large"}]},{"@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\/02a465e9b5b4912eafedd1ae248558fd","name":"Monika Dadool","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g","caption":"Monika Dadool"},"description":"Monika Dadool is a Senior Content Writer at Stellar with over 5 years of experience in technical writing. She is a tech enthusiast and expert who specializes in writing about SQL Server, MySQL Server, MariaDB Server, Microsoft Access, Active Directory, email recovery, Microsoft 365, pattern recognition, machine learning, data recovery, file repair, and operating systems like Linux, Windows, and Mac. She also writes about accounting software such as QuickBooks and Sage 50, as well as web-scripting languages like HTML, JavaScript, Python, PHP, Visual Basic, ASP.NET, and AJAX. Monika is passionate about researching and exploring new technologies, and she enjoys developing engaging technical blogs that help organizations and database administrators resolve various issues. When she's not creating content, you can find her on social media, watching web series, reading books, or exploring new food recipes.","sameAs":["https:\/\/www.linkedin.com\/in\/monika-dadool-105a87163\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/monika\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/142532","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\/82"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=142532"}],"version-history":[{"count":9,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/142532\/revisions"}],"predecessor-version":[{"id":191178,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/142532\/revisions\/191178"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/142561"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=142532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=142532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=142532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}