Solved

Attaching or linking external files to a record in a MS Access form

Posted on 2014-01-28
4
9,586 Views
Last Modified: 2014-01-28
Is there a way to attach or link to a non-Access file within a specific record on a Access form?  For instance, if I have a record for a customer opened in a form and i want to attach ot link to a PDF that contains a credit bureau report or a market research report, is that possible?  Sort of like how reports and files can be linked or embedded in a MS Word document.
0
Comment
Question by:mbilicic
  • 2
4 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 39815467
Access 2007 introduced the Attachment datatype, which allows you to directly embed items like Excel files, PDF, Images, etc. It's easy to use - just add an Attachment field to your table, then drop that field on your form. Access also have an Attachment "control" that can help you work with the attachments associated with a record:

http://office.microsoft.com/en-us/access-help/attach-files-and-graphics-to-the-records-in-your-database-HA001213852.aspx

Be aware, however, that Attachment fields cannot be upsized to SQL Server (or any other database, for that matter).

You could also include attachments by including a link to the item and associate that with your record. To do that, you'd add a new table to your database with fields like this:

RecordID (the Primary Key of the record you want to associate)
ItemLink (a Text or Memo field that will contain the full path to your item)

You could then create a subform based on that table, and drop that onto your parent form. You would include code to allow the user to browse and find items, and you'd then store that link in the new table you created. When users need to view that linked item, you could use the FollowHyperlink method to allow them to launch the item in it's native environment.
0
 
LVL 14

Expert Comment

by:Don Thomson
ID: 39815483
If you are using Access 2003 or lower - just create a field in a table with the Type Hyperlink.
Browse to the File (Any type can be used.

It will most likely work on 2007 and up as well - there are really no restrictions
0
 

Author Closing Comment

by:mbilicic
ID: 39815565
I posted a comment, but not sure if it was accepted.  I had one follow up question. . . if there are multipl eusers of the database and user 1 [based in NY] attaches a file, can user 2 [based in chicago] see the attachment?
0
 
LVL 84
ID: 39816299
If you're using the Attachment datatype, then yes, they would be able to see it.

If you're using the "store the file path" method, then probably not.

How are your remote users running the database? Are you using something like Terminal Services or Citrix?
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now