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