Bloated front end

[Veli Izzet]

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.

 

[John Vinson]

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]

 

[Veli Izzet]

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..