Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-02-28
2
Medium Priority
?
1,428 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

650 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