Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Access10: used for a photos database?
35 views
Skip to first unread message
Peter Jason
May 21, 2012, 6:47:31 PM5/21/12
to
I have Access10 that I use for invoicing etc and I
want to use it for sorting and cataloging my photo
collection.
There are over 3000 photos altogether.
Can someone give me some clue about starting this?
Peter
want to use it for sorting and cataloging my photo
collection.
There are over 3000 photos altogether.
Can someone give me some clue about starting this?
Peter
Access Developer
May 22, 2012, 1:21:46 AM5/22/12
to
There are many software packages for catalogging, searching, and displaying
photos (some/many of them freeware). Some, perhaps all either have graphics
processing capability or the ability to interface with software that does.
To me, it doesn't make sense to invest the time and effort to create one,
with Access, software that is not particularly intended for graphics.
That said, if your requirements are basically for sorting, searching, and
retrieving, you could do so. Again, let me say, I'd consider it only if that
were just a minor part of some larger database application.
In fact, I did just that with Access 2.0, back in the 1990s, with data
stored in a server database (Informix). Access 2.0 could not even display
the graphics files, some of which were scanned text, others were photos. I
had no choice of the graphics software to use, which had been selected by
the prime contractor. I would not have to use it for the same reasons, but
would not use it again for any reason. It had far too much graphics
capability for anything but a dedicated graphics package... editing, an
incredible array of graphic filetypes, but no ActiveX Control accessible
from Access to display the picture. They had to contract a C++ programmer to
create an ActiveX. And, it was very expensive with a "per user" charge, in
addition to a hefty base price.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"Peter Jason" <p...@jostle.com> wrote in message
news:nbhlr7lqbnnil0i7h...@4ax.com...
photos (some/many of them freeware). Some, perhaps all either have graphics
processing capability or the ability to interface with software that does.
To me, it doesn't make sense to invest the time and effort to create one,
with Access, software that is not particularly intended for graphics.
That said, if your requirements are basically for sorting, searching, and
retrieving, you could do so. Again, let me say, I'd consider it only if that
were just a minor part of some larger database application.
In fact, I did just that with Access 2.0, back in the 1990s, with data
stored in a server database (Informix). Access 2.0 could not even display
the graphics files, some of which were scanned text, others were photos. I
had no choice of the graphics software to use, which had been selected by
the prime contractor. I would not have to use it for the same reasons, but
would not use it again for any reason. It had far too much graphics
capability for anything but a dedicated graphics package... editing, an
incredible array of graphic filetypes, but no ActiveX Control accessible
from Access to display the picture. They had to contract a C++ programmer to
create an ActiveX. And, it was very expensive with a "per user" charge, in
addition to a hefty base price.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"Peter Jason" <p...@jostle.com> wrote in message
news:nbhlr7lqbnnil0i7h...@4ax.com...
PW
May 22, 2012, 1:58:05 PM5/22/12
to
FarAway@longago
May 22, 2012, 3:08:22 PM5/22/12
to
Worth doing only either for fun (I did it once) or because you have a
more elaborate data model for the pictures. There are many packages
and online repositories which are very powerful though those I know
don't deal with general binary relations between pictures, for
instance, but just use tags/keywords or intrinsic properties of the
individual pictures and relations which can be derived from these.
(Though I expect some allow XML annotations if that turns you on!)
Tags and properties are usuallyt held in the files themselves (eg
exif, IPTC) (see
http://microstockinsider.com/guides/indepth-iptc-and-exif-data
)
which are probably pretty hard to read in Access unless you are a code
wizard. Any relational data would need to be held in your Access
tables. If you do this you need to give some thought to the key which
identifies the picture in case things become disconnected. If
picture==file, size and crc is the usual solution.
As already noted, Access isn't the easiest environment for displaying
pictures though it is entirely possible.
Best of luck.
more elaborate data model for the pictures. There are many packages
and online repositories which are very powerful though those I know
don't deal with general binary relations between pictures, for
instance, but just use tags/keywords or intrinsic properties of the
individual pictures and relations which can be derived from these.
(Though I expect some allow XML annotations if that turns you on!)
Tags and properties are usuallyt held in the files themselves (eg
exif, IPTC) (see
http://microstockinsider.com/guides/indepth-iptc-and-exif-data
)
which are probably pretty hard to read in Access unless you are a code
wizard. Any relational data would need to be held in your Access
tables. If you do this you need to give some thought to the key which
identifies the picture in case things become disconnected. If
picture==file, size and crc is the usual solution.
As already noted, Access isn't the easiest environment for displaying
pictures though it is entirely possible.
Best of luck.
Phil
May 23, 2012, 5:17:26 AM5/23/12
to
I have a Db which produces a brochure of B & B accommodation with photos and
another one that holds photos of a Yacht Club's trophies. In both cases I
just use an image control and store the path to the photo.
I hace routines that get the file size and retrieve the size of the picture
from the photo.
You may also have to change the registrysettings to stop the annoying message
of something like "Loading JPEG" coming up
HKEY_LOCAL_MACHINE\Software\Microsoft\ Shared Tools\Graphics
Filters\Import\JPEG\Options ShowProgressDialog No
Phil
0 new messages