A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Images and thumbnails questions



 
 
Thread Tools Display Modes
  #1  
Old February 15th, 2010, 10:55 PM posted to microsoft.public.access.gettingstarted
SLow
external usenet poster
 
Posts: 5
Default Images and thumbnails questions

Hello--

I am running XP Pro, with Access 2007. I have several folders, each with
hundreds of image files-- most of these are photo .tifs.

I would like to make a database that contains the file names and key
information about each file (date it was taken, what it is a picture of,
etc.). I want this database to be searchable by users, who will be prompted
to enter criteria for specific attributes ("The photo(s) you are looking and
from what year(s)? _____________"); users must be able to answer in plain
language-- the users cannot be required to enter any code or anything other
than responses to prompts.

I want this database to display representations (thumbnails) of the photos,
without featuring the whole photo. The database should also provide the link
for each photo, so the user can click it to see the original.

Here is what I have tried:

- I attached the photos to each table entry; obviously, this makes the
database swell up quickly, which won't work-- I have less than 100 entries in
the table, and I'm pushing the halfway mark to the Access size limit.

- I tried to enter the images as OLE links. This resulted in the form
displaying the actual link itself, instead of a depiction of the photo
("A_Photo1.tif").


I do not want to convert all the photos to BMP; I need the level of detail
..tifs offer, and the sheer timesuck negates the utility of using a database.
Is it possible to do what I'd like, or is Access the wrong tool for this?

Thanks for any help you can throw my way.










  #2  
Old February 16th, 2010, 03:37 PM posted to microsoft.public.access.gettingstarted
Ed Robichaud
external usenet poster
 
Posts: 90
Default Images and thumbnails questions

Have you looked at the free app, Picassa? It does all the tasks you
described.

"SLOW" wrote in message
...
Hello--

I am running XP Pro, with Access 2007. I have several folders, each with
hundreds of image files-- most of these are photo .tifs.

I would like to make a database that contains the file names and key
information about each file (date it was taken, what it is a picture of,
etc.). I want this database to be searchable by users, who will be
prompted
to enter criteria for specific attributes ("The photo(s) you are looking
and
from what year(s)? _____________"); users must be able to answer in plain
language-- the users cannot be required to enter any code or anything
other
than responses to prompts.

I want this database to display representations (thumbnails) of the
photos,
without featuring the whole photo. The database should also provide the
link
for each photo, so the user can click it to see the original.

Here is what I have tried:

- I attached the photos to each table entry; obviously, this makes the
database swell up quickly, which won't work-- I have less than 100 entries
in
the table, and I'm pushing the halfway mark to the Access size limit.

- I tried to enter the images as OLE links. This resulted in the form
displaying the actual link itself, instead of a depiction of the photo
("A_Photo1.tif").


I do not want to convert all the photos to BMP; I need the level of detail
.tifs offer, and the sheer timesuck negates the utility of using a
database.
Is it possible to do what I'd like, or is Access the wrong tool for this?

Thanks for any help you can throw my way.












  #3  
Old February 16th, 2010, 10:21 PM posted to microsoft.public.access.gettingstarted
SLow
external usenet poster
 
Posts: 5
Default Images and thumbnails questions



"Ed Robichaud" wrote:

Have you looked at the free app, Picassa? It does all the tasks you
described.


Thanks, Ed-- looks like a nifty tool.

You seem to be familiar with Picassa...I could not find a couple answers to
some questions I have about it, when I looked through their online pubs.

- Is it functional in a networked setting? It seems primarily designed for
desktops and local hard drvies.

- Is there a way to share out a Picassa selection of photos to specific
users on the network? It looks like the only sharing method is web-based, and
I don't want to either release the data into the wild, nor give Google my
proprietary content rights.

Thanks again!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.