Results 1 to 4 of 4
  1. #1
    banpreet is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    117

    Working with attachments

    Hey guys,



    I am having little trouble as on my form I am supposed to add attachments (huge pictures). I put a sample picture and it makes the form look ugly and really slow and plus I don't want the database be that big. The problem is that at work, many people don't have access to the same pathway if they want to copy and paste it to a hyper link field in the form, they might need a password or something and some users wouldn't know what file to choose if they clicked the link to the pathway if there were different files in that folder. What would be the best way to figure this out? I am thinking it might take some vba but if anybody can help that would be much appreciated.

    Thanks!

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Which do you want?
    attachments that fill up the database fast
    or
    store the path of the file (UNC path) but not all people can access that drive?

  3. #3
    banpreet is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    117
    I want to store the path of the file but not all people can access that drive

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by banpreet View Post
    I want to store the path of the file but not all people can access that drive
    Instead of storing a copy in your DB as an attachment, store a copy on a share with the appropriate permissions.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-29-2014, 03:19 PM
  2. Replies: 3
    Last Post: 01-29-2013, 04:34 AM
  3. Attachments
    By JayX in forum Access
    Replies: 5
    Last Post: 12-27-2011, 03:08 PM
  4. attachments
    By chiefmsb in forum Forms
    Replies: 3
    Last Post: 08-08-2011, 11:25 AM
  5. Attachments
    By cjp78 in forum Access
    Replies: 4
    Last Post: 05-11-2010, 07:30 AM

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