Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    99

    Angry Unanswered: Record is too large

    When updating an entry through a form I keep getting the error "Record is too large"....

    in non-techie terms, from what I can see the individual is no larger than any others on db that the form allows me to update without probs

    any ideas why it keeps thinking/telling me why record is too large or any solutions.

    Ta very much.

    David
    pachamama
    www.researchbank.co.uk
    Fortune Global 500 Databank

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by pachamama
    When updating an entry through a form I keep getting the error "Record is too large"....

    in non-techie terms, from what I can see the individual is no larger than any others on db that the form allows me to update without probs

    any ideas why it keeps thinking/telling me why record is too large or any solutions.

    Ta very much.

    David
    Well 1st off, how are you updating the record? ADO? DAO? Thru the form?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2004
    Posts
    99
    Thru' form

    Thanks,

    David
    pachamama
    www.researchbank.co.uk
    Fortune Global 500 Databank

  4. #4
    Join Date
    May 2004
    Posts
    1
    the problem is maybe the limits of access text field type

    see more:
    http://support.microsoft.com/default...NoWebContent=1

  5. #5
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    I also have someone I am helping right now that has that same problem... but what the real problem is he has completely filled up many of the records. Like some of the records can hold 10 more characters some only 2. He has all of his information in one table.

    Do you have multiple tables or just one? Is there alot of data in the table giving you the problem?

    The field size also could be an issue. So there are a couple of options. Explore them well.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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