MS Access "record is too large" error (error 3047)

Results 1 to 4 of 4

Thread: MS Access "record is too large" error (error 3047)

  1. #1
    buddhi Guest

    Default MS Access "record is too large" error (error 3047)

    How do I work around this error? When I type in a lot of characeters in to a field, I get the above error. The fields are set to "text" and 255 chars. The entries have never exceeded 255 chars. Please help. Thank you in advance

  2. #2
    Jut Guest

    Default RE: MS Access

    Give this a shot:- Open the table in your database, select View &#062; Design view, locate the Field name you are having problems with, click on the Data type and change it from &#039TEXT&#039 to &#039MEMO&#039. This will then allow up to 65,535 characters instead of 255.<BR><BR>Hope this helps,<BR>jut.

  3. #3
    Join Date
    Dec 1969
    Posts
    32

    Default RE: MS Access

    I usually use the Trim() statement to make sure there are no blank spaces in the fields. See if this helps<BR><BR>Thanks <BR>Jefferys

  4. #4
    Join Date
    Dec 1969
    Posts
    32

    Default RE: MS Access

    Also found this on the Microsoft web site<BR><BR>http://support.microsoft.com/support/kb/articles/Q198/6/60.ASP?LN=EN-US&SD=gn&FR=0<BR><BR>copy the entire two lines into the address of the browser


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


More ASP Resources

Resources:
-- ASP Articles
-- ASP.NET Information
-- 4Guys ASP F.A.Q.
-- ASPFAQs.com
-- ASP Coding Tips
-- Related Web Technologies
-- User Tips!!
-- JavaScripts


Development Centers
-- HTML5 Development Center
-- Windows Mobile Development Center
-- Android Development Center
-- Cloud Development Project Center


Development Technology
Check out these sites for more articles, tutorials, FAQs, discussions, and code!
-- CodeGuru.com
-- VBForums.com
-- DevX.com
-- Developer.com
-- HTMLGoodies