Greetings one and all,
I'm hoping someone can point me in the right direction. To be honest I don't have a clue how I'm going to accomplish this.
To make this simple, all I want to do is have a MS Access database that is located on my workstation have a single form. On this form there is a link, button, or object. It points to a Word doc in a SharePoint 2010 documents library. When the user clicks on the link, button, or object, the MS Word document opens so the user can read/or update the information.
If all of the documents were stored on a shared network drive, this would be easy. I would simply use the OLE object and link the path to documents on the hard drive. Sadly, SharePoint doesn't do OLE, so I'm at a loss in how this can be done.
Any suggestions?