Best way to store photos being added via Access front end RRS feed

  • Question

  • I currently have an Access back end that I am replacing with SQL.  One of the nice things about Access is the attachment data type for photos.  I know SQL does not have this same data type and that storing the images in the file system would be most efficient.

    So, I still need to designate a column to be the reference point to the corresponding photo.  In addition, since users won't be able to attach photos directly in Access, what would be the best procedure for them to link a photo to a record?


    Monday, June 29, 2020 8:39 PM

All replies