Solved

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

Posted on 2011-02-28
2
1,033 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

821 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