Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I made a list of all the major electronics (pc towers, laptops, monitors, etc) at my workplace for inventory. To make it better I wanted to add pictures so I could see what each of the items looked like and a relative location (based on the pic). I did this by adding the pictures inside of comments. As I was going along I realized the file was growing substantially; which normally wouldn't be a problem. My problem was that it grew so large (~500MB I think) it had to 'repair' upon opening every time. When it did this it removed my comments (which included images as well) and I was essentially out of luck at this point.

I removed all the images so I could work on the inventory without any issues, but I really want images on there in some fashion. So my can I achieve this and make it functional? Thanks.

share|improve this question
How big are these images when you view the properties in your (Windows?) explorer? – nixda Jan 9 '13 at 13:27
Roughly ~2MB/each – Josh B. Jan 9 '13 at 15:24
tried to convert them to jpeg, if they are not on that format already? that would slice a big chunk out of the size. – Lorenzo Von Matterhorn Jan 9 '13 at 18:39
Yes they are jpegs taken from my phone of the equipment around the office. – Josh B. Jan 9 '13 at 20:47
Do the images have to be inline? Can't you simply hyperlink to them instead? – Karan Jan 10 '13 at 15:13

First solution you should try:

  • Edit all those pictures down to a very small size - you don't need detailed, high resolution images for this do you?

So take them down to a couple of kb each by resizing and saving as lower quality.

share|improve this answer

My first thought is 2MB for a picture is too high, so you should compress them down. My favorite program for this is Gimp, but I believe there may be some command line utilities out there which are more suited for doing this in batches.

My second thought is, why Excel? You can store images in an Access database easily enough, and this kind of job feels like something you would use a database for (though I admittedly don't know the scope of the project). Converting this into a large scale database (not necessarily Access) might be your best option going forward.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .