Results 1 to 7 of 7

How do I get the attachments to be stored on a shared drive rather than embedded in file?

  1. #1
    chris843 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    3

    How do I get the attachments to be stored on a shared drive rather than embedded in file?

    I'm a new user to Access. We route .pdf documents in our company for peer reviews (workflow type stuff). The Attachment Box is a great addition to the form for people to open the .pdf document when it is assigned to them to review. The problem is that is the .pdf's are getting store within the back-end database file. We've barely used it for 3 weeks, and the file size is already at 60mb. Also the database has corrupted twice. I can't say if that is specifically what is causing the problem, but I need to figure out a way to keep it from exponentially growing the way it is.



    We have the database file located on a share drive currently. Is it possible I can set up a folder and when a user uploads a .pdf within the form, it automatically saves it to the folder rather than the database?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,278
    First and foremost, the db is split into front and back ends, and every user has their own front end? By your post I would guess so. The answer is to store the files in folders and store the paths in the back end. How you do this is a much larger discussion, because it's as simple as manually storing the files, having a form to paste in the path in a table short text field and using Application.FollowHyperlink to open the file
    OR
    using Access to choose the folder, store the file, retrieve it, email it when needed, record routing, date stamp approvals, etc.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.

  3. #3
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    351
    Hmm, maybe this will help...
    https://www.access-diva.com/d15.html
    Gina Whipp
    Microsoft MVP (Access 2010-2015)
    https://www.access-diva.com/tips.html

  4. #4
    chris843 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    3
    This looks useful. I will read up. Thanks!

  5. #5
    chris843 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    3
    Everyone does not have their own frontend and it is opened on our share drive. Backend is obviously on a share drive. Should I be making everyone open their own fronted maybe via their local computer? I thought about if this would help with the corruption.

  6. #6
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    377
    Everyone should have a local copy of the front end on there computer. read up on split databases.
    Here's a start...http://www.fmsinc.com/microsoftaccess/databasesplitter/

  7. #7
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    351
    Hmm, not *should I* but *I will*. This is really a must, IMHO.
    Gina Whipp
    Microsoft MVP (Access 2010-2015)
    https://www.access-diva.com/tips.html

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

Similar Threads

  1. Select File from Computer and Save to Shared Drive
    By sgrimmer in forum Import/Export Data
    Replies: 4
    Last Post: 11-02-2015, 03:43 PM
  2. Shared Drive Access Issue
    By Classic in forum Access
    Replies: 6
    Last Post: 09-23-2014, 06:03 AM
  3. Shared drive path to save attachments
    By zaffar_mughal in forum Access
    Replies: 3
    Last Post: 08-27-2014, 10:43 PM
  4. shared DB on local drive
    By mike02 in forum Access
    Replies: 1
    Last Post: 05-20-2013, 01:54 PM
  5. VBA to save attachments to shared drive via Forms
    By shannonsims in forum Programming
    Replies: 6
    Last Post: 04-04-2013, 03:00 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
  •  
Tech Forums: Microsoft Office Forums