Hello Gurus,

I wrote an app (app1) that consists of a button which when it is pressed it will execute app2. App2 works perfertly when it is executed on it's own and it automatically connects to an Access Database called SampleDatabase2.mdb once it is started. However, when I execute app2 using app1 using the command:

Call Shell("C:\app2.exe", vbNormalFocus)

a error message dialog box with an "OK" button on it appears saying it

"Can't find SampleDatabase2.mdb"

When I click on the "OK" button the main window for app2 appears but app2 doesn't work because it is not connected to the database.
Is there a particular reason why app2 can't connect to the database when I execute it using the command

Call Shell("C:\app2.exe", vbNormalFocus)

from app1?


This error message is really weird and I would really appreciate it if someone can lend me a hand. Thank you!


Marci Sarwan ([email protected])