Solved

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

Posted on 2014-01-28
4
11,476 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 85

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 85
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

687 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