none
Confused about linking documents to a database RRS feed

  • Question

  • I've determined I do NOT want to use the attachment field type because the volume of documents imported into the database would max it out quickly.

    I need to attach multiple documents (PDFs and JPEGs) to a single Order record . . . I assume I want the user to create a link to the file(s) that they have scanned and named in a consistent fashion. . .I can easily control the file folders and naming conventions, so somebody messing up the links is not an issue.

    I'm confused as to how to accomplish this . . do I need a subform with multiple records for each "link" to each document? ? ?

    What field type would I use?

    Any help would be appreciated . . . I'm using Access 365

    PS - is there a way to "un-attach" documents that have been imported using the attachment field, to back up and use the linking option?  I have this in a completely separate database than the question mentioned above.


    Wednesday, October 2, 2019 3:53 PM

Answers

All replies

  • Take a look at http://www.devhut.net/2016/10/03/adding-attachments-to-an-access-database/ it should be all you need to get going.

    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Wednesday, October 2, 2019 3:58 PM
  • You have 2 options

    1st option : the most common one...you store only the filepath (e.g. C:Documents\somePDF.pdf) ..drawback you have to constantly keep the folder/s organized and in case of some "migration" you have to reconstruct everything....

    2nd Option : the unusual one...you store the files on another database engine which is more resilient to file (BLOB) handling and doesn't has the limitations of Access (2GB)...for desktop use is SQLite/Embedded Firebird...for network use Firebird.

    For me the 2nd option is better because you have everything in just one place...you move and you pick a single file and nothing else...there is always the risk of corruption but with a simple backup plan you will always be safe.

    If its for images you can store and retrieve on the fly using the methodology i posted on my Article on Experts-Exchange : https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html

    Wednesday, October 2, 2019 4:49 PM
  • Thanks so much for the recommendation
    • Marked as answer by Big Itch Thursday, October 3, 2019 8:00 PM
    Thursday, October 3, 2019 8:00 PM
  • Thank you for taking the time to give me the options . . I appreciate it.
    • Marked as answer by Big Itch Thursday, October 3, 2019 8:01 PM
    Thursday, October 3, 2019 8:01 PM