A quick FollowHyperlink Question?

[matthewnsarah07]

Hi

I have not used the FollowHyperlink method before and have started to use it to open another Access database. The database is one that opens briefly, emails out a report then show a message box and then quits.

I have used the following

Application.FollowHyperlink "G:\NW REGION OP SUPPORT\Communications\RemoteTest\IBrief Lite.mdb"

All works fine but when the other database exits it leaves an empty access window and on closing this manually, runtime error 87 appears in the main database.

How can ensure the other access window closes automatically and that the error does not recur?

Thanks for your help

 

[the_net_2.0]

instead of followhyperlink, maybe try OPENDATABASE() and CLOSEDATABASE() commands?