Solved

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

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

718 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