open access app from within another access app

[erodjob]

Using access 97 and windows xp. I have a command button that on double click, I want it to open another database. However, I get error message
" Microsoft Access can't invoke the application using RunnApp action."

This is the code I'm using"

Private Sub CorpInvestment_DblClick(Cancel As Integer)

Dim stAppname As String

stAppname = "MSACCESS.EXE \\pershing.com\root\shared\NJ\BONDS\Contacts\Corp-Investment.mdb"

Call Shell(stAppname, 1)

End Sub


any suggestion

 

[Norie]

Is there maybe some code that runs on open in the database you are trying to open?

 

[erodjob]

No.

A friend of mine tried the same code on windows NT, he had no problem. I have XP SP1.

 

[Norie]

I tried it as well on NT and it worked.

Could it be a problem with the path?

 

[erodjob]

What configuration do you have?

I changed it to the C drive and still no good. I do not think it's the path.

Thanks

 

[Norie]

Try creating a new blank database, with one form, one command button and your code.

If it works then it may be something wrong with the original database.

PS

Are you just opening it to get data?

 

[erodjob]

I just want to open it like a shortcut would. Is there another way, that you know of?

 

[Norie]

Not that I know of.

Did you try my suggestion to test if their was a problem with the original database?

Try creating a new blank database, with one form, one command button and your code.

 

[Norie]

What about a hyperlink?

 

[erodjob]

I will try your suggestion if the hyperlink does not work.

How do you do a hyperlink?

Thanks