How To Fix Access 3047 “Record Is Too Large” Error…!
Are you also getting Access database error “3047- record is too large”? Looking for the best fixes to resolve this issue? Well not to worry for this as this tutorial will guide you in fixing up this this Record Is Too Large Access Runtime Error.
The error record is too large usually comes when you update or add a text field in table and the table record size exceeds the limit of 2000 bytes for all fields combined.
Record is too large.
Trappable Error code is 3047
Cause Of Access Error 3047 Record Is Too Large
Actually the error is because of the reason that records in table of Access database are having a limit of fewer than 2k, excluding the memo fields. So, when you enter data into such record not when you define the table structure then the error will surely get raised.
Resolution To Fix “Record Is Too Large” Error
Fix 1: Using Fields With The Memo Type
The resolution that you can try to fix this error code 3047 is by making use of Memo type instead of Text type. You need to set the field type property to 12 in order to get the memo type.
When memo field exceeds the limit of 250 bytes or whenever the 2k limit is reached on a record, Visual Basic will automatically puts the memo fields on a separate page in the database file. You should improve space usage by concatenating the fields into one large memo field.
Fix 2: Using DoCmd.TransferSpreadSheet Method
According to the Access 2016 specification, Access table has a fixed limit of 4000 records and the total size of Access is 2 GB. So, if a table contains more than 4000 records, then you will receive an error message “Record is too large” also referred as “error 3047”.
To fix this issue, you can make an Excel worksheet and use linked table. So, this means that you create a query having more than 4000 records and then export it to excel without any issue.
However when you have several export queries, then you need to do it in VBA. When using DoCmd.TransferSpreadSheet Method, to export the Query / Table to Excel, this particular error 3047 would prevent you to do that.
Fix 3: Use Access Repair And Recovery Solution
Other than these manual solutions you have an alternative option of making use of Access Repair and Recovery Tool. This tool is designed to repair and recover all versions of Microsoft Access database such as 2016, 2013, 2010, 2007, 2003, 2000, etc. and repair both access (.mdb & .accdb) database file format.