Linking a Word doc on a SharePoint site on a MS Access form

[JustAnElf]

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?

[June7]

The only possibility I can think of is hyperlink. I know next to nothing about Sharepoint so just did a quick Bing search: hyperlink to open sharepoint word document

Found something about entering document url into IE address bar. Does that make sense to you?

[JustAnElf]

Hi June7,
What you are saying does make sense. Based on your suggestions I was able to figure out how to make it work through hyperlinks.

[June7]

Any info about the method you can offer that would help someone else?