Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2019
    Posts
    20

    Create a photo album stored in Access that can be referenced and displayed in a form

    I am creating a database that stores information about machines in a manufacturing plant. Part of that information is pictures. There are a number of cases in which multiple machines require the same picture. At the moment, I am storing the pictures and machine information in a single table, using the attachment data type to store the pictures. The problem is I am storing multiple copies of the same picture in the same database, which seems unnecessarily tedious and resource intensive.



    Is there a way I could create a single table to store all my pictures, then be able to reference a given picture in a table or query, so that when I create a form or report based on the table/query, the form/report will display the pictures?

    Thanks!

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Save all your pictures in folders and only store the path to those photos in your database.
    You display the pictures in an image control with the path set as the control source.

  3. #3
    Join Date
    Jun 2019
    Posts
    20
    Is there a way I could do the same thing but store the pictures within Access itself? I understand there is the risk of bloating the database, but in this case I would prefer not to separate the pictures folders from the Access database.

  4. #4
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    I'm sure you probably could but I don't go anywhere near attachment fields in any of my projects. They are too much of a P.I.T.A. to work with and it doesn't take long to bloat a database to the point that it is unusable. How many pictures do you have and how large are they?

  5. #5
    Join Date
    Jun 2019
    Posts
    20
    Let's say up to 100 pictures. The pictures are JPEGs, each being about 400 KB in size.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-21-2018, 05:02 PM
  2. Replies: 0
    Last Post: 06-23-2016, 05:09 PM
  3. Replies: 1
    Last Post: 03-05-2014, 07:55 AM
  4. Replies: 1
    Last Post: 06-27-2012, 09:16 AM
  5. Stored vs. Displayed Data for a ComboBox
    By tylerg11 in forum Forms
    Replies: 1
    Last Post: 12-14-2011, 03:11 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums