Solved

How to remove all Images used as backgrounds from Access 2010 database

Posted on 2011-02-28
2
961 Views
Last Modified: 2012-06-27
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....

Bluemercury
0
Comment
Question by:bluemercury
  • 2
2 Comments
 
LVL 1

Accepted Solution

by:
bluemercury earned 0 total points
ID: 34998340
OK guys - managed to answer it for myself. Here's what I did, for the benefit of others....

Firstly, it didn't help that navigation had been turned off by the DB creator, so I couldn't access and edit existing tables, reports, etc, To turn this on, I went to File -> Options -> Current Database -> [tick] Display Navigation Pane

With this on, I could then look further at editing the forms. A few background pics were still left on some forms, and I took these out by setting the 'Picture' property to nothing, in the design view.

This still didn't fix my original problem. But then I found that the images embedded were done using the 'Shared' method, by also looking at the form properties.

To get rid of the pictures for good, I found that in design view for e given form a 'Design' tab appears at the top, and under here is a 'Insert Image' button. Clicking on here will bring up all the shared images stored in the DB already, and you can right click and delete them. I did this for all the Images that had been added and shared in this way.

Having done this, the final step is running the 'Compact & Repair' from the File menu (under the info option) and you should find the Access file dramatically reduces in size.

I hope this finding helps anyone else out who suffered the same issue as me! :D

Bluemercury
0
 
LVL 1

Author Closing Comment

by:bluemercury
ID: 34998345
This is the resolution to the problem
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now