RSpringuel General User

Joined: 31 Mar 2007 Posts: 22
|
Posted: Thu Nov 13, 2008 8:14 am Post subject: Removing images from a database |
|
|
So, I've been working with a database in which I originally had an image field and was actually depositing the images in that field. However, the database size has bloated as a result of the number of images within it and I'm noticing a significant degradation in the performance of OpenOffice when the database is open as a result. Since there are still more images that I want to add to the database, I've decided that it would be best to switching over storing just the file names in the database and using macros to make the images show up in a form or report.
As a result, I need to take the images out of the database. However, when I deleted the image field from the appropriate table, the database size didn't change and OpenOffice performance remained the same. This, to me, indicates that the images are still in the file, even though the field in which they were stored was deleted. How do I efficiently go about removing the images from the file? _________________ Just in case I forgot this in the post:
OOo 3.0.0
Mac OS 10.4.9 and Windows XP |
|