Results 1 to 7 of 7
  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 online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Hmm, maybe this will help...
    https://www.access-diva.com/d15.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
    Location
    Ma.
    Posts
    1,643
    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
    377
    Hmm, not *should I* but *I will*. This is really a must, IMHO.

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
  •  
Other Forums: Microsoft Office Forums