Solved

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

Posted on 2011-02-28
2
827 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

762 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

19 Experts available now in Live!

Get 1:1 Help Now