Nancy,
see access help for "shell"
I'm pretty sure there are other methods that will work but the following
works in my application.
You should have all of the documents in one folder on the server and
reference to them. You don't want the documents to actually be in your
application.
You just want to reference their location so Access can find them.
You will have to change the file path to your actual file path.
In the following you will have to change [MsdsNumber] to the name of the
field where you have the file name stored.

Private Sub cmdMSDS_Click()
'Open the Tech Sheet file.

Dim stAppName As String
Dim FilePath As String
Const cstrPath As String = "\\Paul\MSDS\"

FilePath = cstrPath & [MsdsNumber] & ".pdf"

stAppName = "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe " &
FilePath

Call Shell(stAppName, 1)

End Sub

You can just use a Hyperlink field in a table, put this in text box on a form
and some code that uses Application.FollowHyperlink.