By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,817 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

Storing JPEG Thumbnails

P: n/a
Greetings all,

As a newbie, using Access 2000, I would appreciate advice on the best
way to include pictures.

I have developed a 'Home Inventory' database which can include jpeg
thumbnails of my items and I can review things at anytime - on the desktop
where I created all this - no problem so far.
I networked the mdb file (only) across to my laptop and found the
pictures don't show. So I guess my database table is only storing links to
the images.

What I really want to do is keep a copy of the database, including the
pictures, on a CD-R, far from the house - so that all the data is available
after a: fire, flood or earthquake.

Question 1. Is it possible, and a good idea, to store the jpeg images
within the mdb file.

Question 2. Is it better to keep the jpeg images in a folder
alongside the database (on the CD-R). In which case, do I also need to keep
the EasyPhoto application that I chose from the 'Object Types' available
after I had hit on 'Insert Object'.

Question 3. What is the best way of getting from 'Insert Object' to a
folder full of jpeg images (I know I don't want to insert Excel Worksheets,
Word Documents, PowerPoint Presentations etc, and EasyPhoto seems a rather
long way round).

Thanks in anticipation.

Rednelle
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Solved my own problem using IrfanView Graphics - with a tiled display - copy
and paste.

Rednelle
"Rednelle" <re********@btinternet.com> wrote in message
news:cf**********@titan.btinternet.com...
Greetings all,

As a newbie, using Access 2000, I would appreciate advice on the best
way to include pictures.

I have developed a 'Home Inventory' database which can include jpeg
thumbnails of my items and I can review things at anytime - on the desktop
where I created all this - no problem so far.
I networked the mdb file (only) across to my laptop and found the
pictures don't show. So I guess my database table is only storing links to
the images.

What I really want to do is keep a copy of the database, including the
pictures, on a CD-R, far from the house - so that all the data is available after a: fire, flood or earthquake.

Question 1. Is it possible, and a good idea, to store the jpeg images within the mdb file.

Question 2. Is it better to keep the jpeg images in a folder
alongside the database (on the CD-R). In which case, do I also need to keep the EasyPhoto application that I chose from the 'Object Types' available
after I had hit on 'Insert Object'.

Question 3. What is the best way of getting from 'Insert Object' to a folder full of jpeg images (I know I don't want to insert Excel Worksheets, Word Documents, PowerPoint Presentations etc, and EasyPhoto seems a rather
long way round).

Thanks in anticipation.

Rednelle

Nov 13 '05 #2

P: n/a
Can you please mail me the code & explain further what exactly you're
doing to display the thumbnails & what would be reqd if I want to
install the application on another machine too. Would I be reqd to
install IrfanView there too.

1) Are you storing only thumbnails or even the larger size pics ?

2) If anyone clicks on the thumbnails, does he get to see the larger
ver of the pics ?

3) Are you storing within the database or just linking (pointing) to
the location of the images lying externally.

4) Will the dispay of images be dependent on the presence of any
external image viewer like IrfanView & if so ... why ?
I'd sincerely appreciate a detailed explanation. Sorry for any
trouble.

Thx & Best Rgds,
__________________________
Prakash T. Wadhwani
Cell : 968-9316201
Email: si****@omantel.net.om

You're Never Dressed For The Day
Until You Wear A Smile :-)


"Rednelle" <re********@btinternet.com> wrote in message news:<cf**********@sparta.btinternet.com>...
Solved my own problem using IrfanView Graphics - with a tiled display - copy
and paste.

Rednelle
"Rednelle" <re********@btinternet.com> wrote in message
news:cf**********@titan.btinternet.com...
Greetings all,

As a newbie, using Access 2000, I would appreciate advice on the best
way to include pictures.

I have developed a 'Home Inventory' database which can include jpeg
thumbnails of my items and I can review things at anytime - on the desktop
where I created all this - no problem so far.
I networked the mdb file (only) across to my laptop and found the
pictures don't show. So I guess my database table is only storing links to
the images.

What I really want to do is keep a copy of the database, including the
pictures, on a CD-R, far from the house - so that all the data is

available
after a: fire, flood or earthquake.

Question 1. Is it possible, and a good idea, to store the jpeg

images
within the mdb file.

Question 2. Is it better to keep the jpeg images in a folder
alongside the database (on the CD-R). In which case, do I also need to

keep
the EasyPhoto application that I chose from the 'Object Types' available
after I had hit on 'Insert Object'.

Question 3. What is the best way of getting from 'Insert Object' to

a
folder full of jpeg images (I know I don't want to insert Excel

Worksheets,
Word Documents, PowerPoint Presentations etc, and EasyPhoto seems a rather
long way round).

Thanks in anticipation.

Rednelle

Nov 13 '05 #3

P: n/a

"Rednelle" <re********@btinternet.com> ha scritto nel messaggio
news:cf**********@sparta.btinternet.com...
Solved my own problem using IrfanView Graphics - with a tiled display - copy and paste.

Rednelle


Can you show us something about and not only the Resolution Notice...!!!

@Alex.
Nov 13 '05 #4

P: n/a
Greetings again,

I have found 3 different ways to attach images within MS Access - all
via an OLE bound object - but the efficiency of each technique and the
convenience of each technique seem to vary considerably.

Starting with Access 2000 and an mdb file of 708Kb before any images
were added - I including 3 jpeg thumbnail images each of 14Kb.

1. The least efficient technique is to cut & paste. The Access file grew
to 1408Kb. No application (other than Access) is required to subsequently
view the images. The images display instantly in FormView. Adding images
this way involves copying them to the clipboard (which is where I used
IrfanView) and then pasting them into the OLE field on your Form.

2. Using the 'EasyPhoto' application, which I think came bundled with my
digital camera software, adding the 3 jpeg images caused the Access file to
grow to 800Kb. 'EasyPhoto' must be installed on the computer to display the
images. The images displayed in FormView with less than a 1 second delay and
no other operator action. Adding images this way involves hitting on 'Insert
Object' / 'Create New' / and your chosen image handling (in my case:
EasyPhoto) application.

3. The most efficient way is to 'link' images to your Form. My Access file
grew to 736Kb. No special photo application is required. Adding images
this way involves hitting on 'Insert Object' / 'Create from File' / and
finding the path to your image. However, to subsequently review the image
you must double click on the icon displayed on your Form field - and it will
appear in a new window, provided the path remains unchanged - you must later
close that window to get back to Access.
Please remember I am very new here and there may be very much better ways of
attaching pictures within databases.

Rednelle


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.