Thursday, 7 December 2017

Fixes To Resolve Access 3047 “Record Is Too Large” Error



Does your access database frequently encountering the error “record is too large”? If yes then just follow the workarounds needed to fix this Access Runtime Error 3047.

Issue:

Ms Access is pseudo-relational database engine from Microsoft that can be used to add, view, share, delete and organize data stored in the database. It consists of objects, macros, tables, queries, modules & forms. Former version of access database creates file with .mdb extension whereas the newer edition of access database make use of .accdb file format.

Although Microsoft access is a database management system but unfortunately it doesn’t allow users to put over the limit data in the database.

When access database data limit exceeds the following error “record is too large” seems to encounters each time when tries to update or add a text field in table. usually the issue generate when the record size  exceeds about 2000 bytes for all fields combined.


Resolution to fix “record is too large” error


Fix 1: redefine the table again by creating some short fields or by removing unnecessary fields.

Fix 2: You can avoid this access error 3047 by using fields with the Memo type instead of Text type. Set the field type property to 12 in order to get the memo type, instead of 10 to get a text type. When memo field crosses 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. If you text field has such related data, you could improve space usage by concatenating the fields into one large memo field.

Fix 3: Use Access Repair And Recovery Solution


If you don’t wants to go with the manual or programmatic code then also you need not to worry just try the Access Repair And Recovery tool. As, it is the simplest and easiest way to recover up your lost Access Database password. This is the most appropriate software that is particularly designed to repair corrupt or damaged MS Access database files. It comes with powerful algorithm that scans even severely corrupted access database files.


      

Conclusion:

Try the fixes carefully but if you are not so sure about performing manual solution correctly then go with automatic solution i.e Access Repair & Recovery Tool. As it can easily be performed by novice user and doesn’t require having any technical knowledge.

1 comment:

  1. With the help of this application user can easily restore all MS Access database objects like Table, Deleted Records, Forms, Macros, Linked Tables, and Indexes etc.

    ReplyDelete