×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Alternative to Attachment field

Alternative to Attachment field

Alternative to Attachment field

(OP)

My client uses a Jobs table with attachment field to store JPG scanned images of the work being done, maybe as many as 8 images. The backend database containing the table is growing rapidly, already up to 0.75GB and likely to go on growing at the same rate.

Instead is there a way to store just the links to each image and allow the client to display them as needed, preferably full screen. That would reduce the size of the backend dramatically.

I started out along the lines of trying to archive non-current records but ran into the fact that Access can't append attachment fields.

RE: Alternative to Attachment field

I typically store the path to the images. If all the images are in the same folder, I might store the path to the folder in a table and then only store the unique path\file.jpg in the table of images. There are lots of examples on the web regarding how to display the images in a form or report.

Duane
Hook'D on Access
MS Access MVP

RE: Alternative to Attachment field

(OP)

Thanks Duane. I've done this for my own use but my client would probably find it tedious to have to find the file location and paste it in, compared with the convenience of using an Attachment field.

Would it be possible to create some sort of browse facility so she could steer to where the images are stored, then select and add to the field containing the link? You may have indicated this in your answer but I didn't understand by 'store the path to the folder in a table and then only store the unique path\file.jpg in the table of images'.

RE: Alternative to Attachment field

(OP)

Thanks Duane, you're continuing help is much appreciated. I found a good solution in TheAceMan1's contribution to this post

http://www.tek-tips.com/viewthread.cfm?qid=1289131

This does what I want and allows selection of a file then creation of a link to it in a text box. To make the link work I had to adapt the call to say

me.Textboxname = Browsefiles()
me.Textboxname = me.Textboxname & "#" & me.Textboxname & "#"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close