Managing Database Size 2

[ottograham]

My Access 2000 database has grown quickly to a 230MB file size. I compacted it, but it was reduced to only 216MB.

There is not that much stuff in it. Are there any tricks to cleaning it up and keeping the size manageable?

Thank you in advance for your help.

 

[japyy]

If it's a db you used to devellop in, and you made a lot of changes on the way, it might help to make a new (empty) database and import all objects from your old one.

 

[tlbroadbent]

Are you storing images or using images on forms. They could be bloating the database. Terry

http://www.defendscouting.com/

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[ottograham]

Thank you japvv and Terry.

Terry: Yes - I'm using images of Adobe files as background images for forms. I'd like to find a way to use the original PDF file, but have posted questions about Adobe ActiveX controls for PDF files with little response. It would be great, because the original PDF files are 15-20K, and the images are very large.

If you know a better way, please let me know. Thanks!

Scott

 

[Francescina]

Images are bloating up MDB files to an incredible extent. 1000 % and MORE is not an exception!
If you use these images as mosaic then things get even worse.
It is best not to use background images at all for memory usage reasons as well (see ACCESS ONLINE ENCYCLOPEDIA article about the ACCESS memory leak). If you absolutely need them then you should use the BMP format.
If you store images in a table then the same problem arizes but there are several solutions (see Graphic powerup program "solutions"-page at

http://www.unsoftwareag.com).

 

[AlexMidd]

Thanks to japyy! I have had two databases, very similar, for development. One was 5MB and compacted to around 900KB. The other was 3.5MB and compacted to about 3.3MB. This was a pain and I could not see any reason for it.

I have just done what japyy said and it has now compacted to just over 1MB! Brilliant! I'm as happy as Larry now.

LOL Alex Middleton

 

[ottograham]

Francesina:

Thank you. This helps to explain it.

The solution offered by the Graphics PowerUp program does not list PDF as a file type. The documents I'm working with are all in PDF, and the file size is small. If I could create a control using the native PDF file as the background and plop the text controls on top, that would be very nice.

Someone else says he has done it. I'm working to see if it works for me.

Thanks again for your help.

Scott