Front End file size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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).
 
On Sun, 27 Jun 2004 20:41:01 -0700, Robert Grant <Robert
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.
Click to expand...

Have you Compacted the database? Frontends need compaction too!
 
John Vinson said:
On Sun, 27 Jun 2004 20:41:01 -0700, Robert Grant <Robert


Have you Compacted the database? Frontends need compaction too!
Click to expand...
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.
 
Back
Top