Results 1 to 2 of 2
  1. #1
    lepsid is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2013
    Posts
    2

    storing documents in ACCESS 2013 outside the database

    Hello!
    I am new one in using access 2013. I have created table and form in database. One of the field is "attachment" field. I realized that MS access stores "attachments" data inside the database, which increase the size of database. I know there are some limitation in Access database size (up to 2 GB). I don't want that adding attachments increase the database size. So, I'd like to store the documents externally, outside the access database, in some folders. So, is it possible to do in the MS Access 2013, and if so, how? Is there some settings for storing the documents externally?

    Thank you very much

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    I just store the path of the file in a text field. You can use FileDialog or this type of thing to let the user point to a file:

    http://access.mvps.org/access/api/api0001.htm

    You can use FollowHyperlink to open files for user viewing.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 10-14-2013, 12:59 PM
  2. Replies: 1
    Last Post: 10-14-2013, 03:54 AM
  3. Replies: 4
    Last Post: 08-21-2013, 07:08 AM
  4. Replies: 12
    Last Post: 07-25-2013, 12:49 PM
  5. Access 2013 Database Name
    By Sparky in forum Access
    Replies: 2
    Last Post: 06-28-2013, 04:07 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