Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2012

    Unanswered: Record is too large 3047


    I have a database of courses at a University which has 8 tables each with a unique course code that I have used as the primary key.

    All tables are linked using the same key - course code.

    I have a form which contains 54 fields (these 54 fields are divided into 8 tables)

    However when I try to update a record using the form, I keep getting this error:

    Records is too large (3047) You defined or imported a table with records larger than 4K

    Please can someone help?

    I'm teaching myself Access so please be kind if I'm doing something stupid

  2. #2
    Join Date
    Oct 2012
    Forgot to mention - I am using one big query as the record source for the form which queries all 8 tables

  3. #3
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    It sounds like your database design is a little screwy. Can you post table descriptions, relationships and the base query? Failing that, make a copy of your database, remove any confidential information, zip it and post it here.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

  4. #4
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    As weejas said, your overall design sounds suspect! The fact that all Tables are linked by a single Field merely reinforces this!

    Cramming the data from multiple Tables into a single Form, being used for data entry, by way of a Query, is seldom a good idea. Generally speaking, this sort of thing would be handled using a Main Form and multiple Subforms, but the exact answer would be dependent on the table descriptions and relationships weejas asked for.

    We frequently speak of apps not being Normalized, but apps can actually be over-normalized, as well, making tasks such as data entry problematic, without actually adding anything to the app.

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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