Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2011

    Unanswered: Help with Access for Managing Photographs

    I am tasked with setting up a database that can handle between 4 and 6k photographs.

    Photos are for a floral designer. They need to be categorized by color scheme, price, type of event, etc.

    Client only has MS Access available and I am looking for suggestions on setup.

    The GUI is straightforward, however these photos somehow need to be categorized in the DB to allow the user to pull the images by category, price, etc.

    There is intensive setup in categorizing the photos manually, however, can access pull a batch of images and display them? I am not fluent in vb scripting, but can get help, just looking to see if this is something that is possible so I can get headed in the right direction.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    If I were asked to do this, I'd store all the photos in a known folder location and then keep track of just the filepaths to the photos in the Access database. Displaying photos is pretty easy if you have a path the photo(s) you'd like to have displayed.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2011

    orectim such

    I agree with Terry. The files should definitely be held outside the database. I once worked for a shoe manufacturing company and they hired a friend of mine who wrote them an access database. They required 2 pictures of each shoe (one sketch and one Final photo) and needed to print them as needed. I remember her telling me addressing the files was by far better then trying to hold the hugh files inside the program. If you want I can give you the link to my friends site that discusses the catalogue database.

  4. #4
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    I wrote a visits database that needed a photo I'd stored in it
    Mark1 had the image stored in the database after about 6 months the database got huge I mean huge
    Then I rewrote it storing the image out side the database delete that field and the database shank by heaps
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts