Open another database from existing database

[Phil Chan]

Hi,

I am using 97 Access and would like to create a code to
open another database from the existing database form.

Private Sub TDActualGP_Click()

Dim stAppName As String

stAppName = "C:\Program Files\Microsoft
Office\Office\msaccess.exe" & "/user" & "'PHIL'" & "/pwd"
&_ "'DENNIS'”_"I:\Accnting\TDProposal.mdb"

Call Shell(stAppName, 3)

End Sub

Both database are password protected. I have already
tried almost all combination of “stAppNmae” but it still
did not work. I am wondering if it is possible. If yes,
please help. Am I going to the right track?

Thank you so much for any help.