Import Attachments from MS Access to ArcMap

1185
0
02-13-2017 02:11 PM
Labels (2)
PennyLane
New Contributor

Hello,

I have a MS Access database pertaining to archival documents in a Park. I have Lat/Long coordinates associated with some documents as well as an Attachment field that contains the PDF of the document. I have linked this database with ArcMap via an OLE connection. I have successfully been able to display the Lat/Long (X/Y data) on the map but can not get a link to the PDF. When I open the attribute table the Attachment field is saved as a "BLOB". Is there anyway to hyperlink this?

I want the end users to insert data, attach the document into a form on MS Access and have that information automatically be updated in ArcMap. Is there a way to do this?

I am currently working with ArcMap/ArcCatalog 10.0 and MS Access 2010

Many Thanks!

0 Replies