×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ERROR 3047- RECORD IS TOO LARGE

ERROR 3047- RECORD IS TOO LARGE

ERROR 3047- RECORD IS TOO LARGE

(OP)
I try to add data into my table after creating the form and it tells me that Record is too large, error 3047. So I am stuck....Can You help

RE: ERROR 3047- RECORD IS TOO LARGE

Hi!

Enlarge field size in the table or compare length of entered value on TextBox_BeforeUpdate procedure!

Aivars

RE: ERROR 3047- RECORD IS TOO LARGE

I have the same error  3047 showing up, it causes a synchronization to fail in my client's database.  All the literature seems to say the same things as the suggested reply here (enlarge field sizes).  In my case, I have no information from Access (A2K) as to which table is the offender.  I am guessing that it's my largest (record size) table.  Calculating from my design specs, it's less than 600 bytes.  How does my user get 1400 more bytes into it to cause this failure?  Is it possible there is another table (not a "user" table) that is really the error causer?

Thanks.

RE: ERROR 3047- RECORD IS TOO LARGE

Hi, xbigblue!

You can create Memo field for long data.
Aivars

RE: ERROR 3047- RECORD IS TOO LARGE

Hi, Aivars -

I did not state my post too well.  I did not mean literally "how can my user get 1400 more bytes of data in?", but I was saying " What could they have done to mess it up this badly - I didn't see any way they could enter an excess 1400 bytes."  I already have a memo field in the suspect table for long text entry but Access documentation says the contents of memo field do not count against the 2048 byte limitation.  

I'm still looking for guidance on how to find and fix the root problem.  

RE: ERROR 3047- RECORD IS TOO LARGE

Hi again!

Maybe it is worth-while to save your long data in the separate files on hard disk or server and then make hyperlinks to its?

Aivars

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close