News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Error 3163 – Please Assist

    Posted on WSCWaldman Comment on the AskWoody Lounge
    Viewing 1 reply thread
    • Author
      • #351480 Reply
        AskWoody Lounger

        When I try to compact my database I get the following error:

        “Error 3163… Field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.”

        I am clueless what this means or stems from. I did a Repair, but the problem still occurs.

        Any ideas how to correct it?

        I am using Access 97 and Win. 98.

      • #508636 Reply
        AskWoody Lounger

        Check your tables and make sure you don’t have any default values that are bigger than the field size can handle.

        If that doesn’t work, try pulling out any tables with memo fields and putting them into another database temporarily. If your database compacts without the memo fields, you probably have a corrupted memo field and you’ll have to track down the table and eliminate the memo field in order to get it to behave in your main database. Once you’ve compacted it, you should be able to add a memo field to your table design, create a link to the errant table in the other database, and use an update query to repopulate the new memo field. You might also want to truncate the entries to some reasonable length to make sure you don’t pick up whatever caused the original corruption.

        • #508665 Reply
          AskWoody Lounger

          Found 3 corrupted records.



    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Error 3163 – Please Assist

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.