Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Bloated front end

Discussion in 'Information Technology' started by Veli Izzet, Oct 28, 2005.

Tags:
  1. Veli Izzet

    Veli Izzet
    Expand Collapse
    Guest

    Hi all,

    I have a front-end application and a back-end.

    The front-end app was around 8 MB. I added just one field to a table in
    the backend, and put that field on only one form on the front-end, and
    the application bloated to 40+MB.

    I tried compacting, and then backed the app up. It still stays at 40+MB.

    Any insight to that?

    Thanks for answers.
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 28 Oct 2005 10:19:15 +0300, Veli Izzet <veli.izzet@gmail.com>
    wrote:

    >Hi all,
    >
    >I have a front-end application and a back-end.
    >
    >The front-end app was around 8 MB. I added just one field to a table in
    >the backend, and put that field on only one form on the front-end, and
    >the application bloated to 40+MB.
    >
    >I tried compacting, and then backed the app up. It still stays at 40+MB.
    >
    >Any insight to that?
    >
    >Thanks for answers.


    YOu very likely have some sort of corruption - it may be causing the
    bogus JET error in your other message as well.

    See http://www.granite.ab.ca/access/corruptmdbs.htm for some possible
    causes and solutions.

    You may need to create a new, empty frontend and import the objects in
    this one - EXCEPT for the one form you changed. I'd suggest rebuilding
    that one from scratch, as it appears to be the corrupted object.

    John W. Vinson[MVP]
     
  4. Veli Izzet

    Veli Izzet
    Expand Collapse
    Guest

    Thanks, yes it was due to corruption..

    I found out that the backend was in Access 2000 (do not know why). I
    converted it into Acess 2003 format, and the corrupted memo field became
    availabe (filled with ###), I erased the data, and the problem was gone..

    John Vinson wrote:
    > On Fri, 28 Oct 2005 10:19:15 +0300, Veli Izzet <veli.izzet@gmail.com>
    > wrote:
    >
    >
    >>Hi all,
    >>
    >>I have a front-end application and a back-end.
    >>
    >>The front-end app was around 8 MB. I added just one field to a table in
    >>the backend, and put that field on only one form on the front-end, and
    >>the application bloated to 40+MB.
    >>
    >>I tried compacting, and then backed the app up. It still stays at 40+MB.
    >>
    >>Any insight to that?
    >>
    >>Thanks for answers.

    >
    >
    > YOu very likely have some sort of corruption - it may be causing the
    > bogus JET error in your other message as well.
    >
    > See http://www.granite.ab.ca/access/corruptmdbs.htm for some possible
    > causes and solutions.
    >
    > You may need to create a new, empty frontend and import the objects in
    > this one - EXCEPT for the one form you changed. I'd suggest rebuilding
    > that one from scratch, as it appears to be the corrupted object.
    >
    > John W. Vinson[MVP]
     

Share This Page