Front End file size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert Grant - 28 Jun 2004 04:41 GMT

Despite deleting almost all the forms and tables for my .mdb file even after compacting it seems to have reduced very little in size. In fact over the years this application just keeps growing in size even though large objects are being removed.
What is even more confusing is when its loaded into a terminal server environment and bought back into my developemnt environment the size decreases dramatically.

Reply to this Message

Albert D. Kallal - 28 Jun 2004 11:17 GMT

Hum, about the only thing I can think of is that you have used graphic
images for the forms backgrounds.

They are horrible, as these images are NOT compressed.

If your front end does NOT have nay graphics images, then I would try making
a mde, and see what the size of that is..is it small?

Further, some bloating issues were fixed by installing the updates to
office, and the JET. (this is especially true in access 2000).

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.attcanada.net/~kallal.msn

Reply to this Message

John Vinson - 28 Jun 2004 21:08 GMT

>Despite deleting almost all the forms and tables for my .mdb file even after compacting it seems to have reduced very little in size. In fact over the years this application just keeps growing in size even though large objects are being removed.
>What is even more confusing is when its loaded into a terminal server environment and bought back into my developemnt environment the size decreases dramatically.

Have you Compacted the database? Frontends need compaction too!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message

Robert Grant - 30 Jun 2004 09:53 GMT

> >Despite deleting almost all the forms and tables for my .mdb file even after compacting it seems to have reduced very little in size. In fact over the years this application just keeps growing in size even though large objects are being removed.
> >What is even more confusing is when its loaded into a terminal server environment and bought back into my developemnt environment the size decreases dramatically.
[quoted text clipped - 4 lines]
> Come for live chats every Tuesday and Thursday
> http://go.compuserve.com/msdevapps?loc=us&access=public

I've tried compacting it many times to no avail. What I might try doing is pasting all the objects into a new mdb file and see if that helps. I'm pretty certain I've got all the latest SPs installed, I'll check that as well.
Everything is working OK but this application gets uploaded onto client systems via dialup so obviously there's good reason to keep the size down.

Reply to this Message