I havn't used the hyperlink method, so not sure how it works. I use the following code behind a command button.
Private Sub cmdOpenDB_Click()
On Error GoTo Err_cmdOpenDB_Click
Dim strAppName As String
strAppName = "C:\Program Files\Microsoft Office\Office\msaccess.exe " & "PathAndDBName"
Call Shell(stAppName, 1)
DoCmd.Quit
Exit_cmdOpenDB_Click:
Exit Sub
Err_cmdOpenDB_Click:
MsgBox Err.Description
Resume Exit_cmdOpenDB_Click
End Sub
David