How to remove all Images used as backgrounds from Access 2010 database
Posted on 2011-02-28
Hi guys. I hope someone can help me.
I have had a project dumped on my lap, to make more efficient a invoice management system that some one else has developed in Access 2010 (and is leaving our workplace). For reasons known only to the person, they put 'pretty pictures' on every single form (of which there must be about 50 forms) and the overall database size is about 45 MB, instead of being the few hundred kilobytes I'd have anticipated.
The user has gone through and deleted most of the images, but the file size does not reduce. Additionally, I have run a compact and repair, and still it doesn't reduce. I can only assume that whilst the pictures have been removed as backgrounds, the actual JPEG data is still buried in the DB somewhere......
Does anyone know a simple way I can remove all embedded JPEGs? Better still, a method for commanding all background images set to go would be good too - just to be sure they are all gone from forms.
I used to use Access a lot up to version 2003. The new ribbon based versions are leaving me a touch confused as to how to get to things though. So a pointer (for example) on bringing up existing tables for editing would be ultra appreciated as well.
Many thanks in advance....