Start mdb from mdb

[Harmannus]

Hallo,

How can i start another mdb (like the one below) from within an active mdb?
e.g.
c:\myapp\newapp.mdb

Is it possible to check if the mdb is present and if not skip the start?

Thanx for any tips

Regards,

Harmannus

 

[Naresh Nichani MVP]

Hi:

You could try this code like this --


Dim objAccess as Access.APplication

if VBA.Dir("c:\myapp\newapp.mdb") <> "" then

Set objAccess = new Access.Application
objAccess.Visible = True
objAccess.OpenCurrentDatabase "c:\myapp\newapp.mdb"
else
Msgbox "Cound not fund 'c:\myapp\newapp.mdb'",vbInformation
end if
Regards,

Naresh Nichani
Microsoft Access MVP

 

[Harmannus]

Hallo,

Thanx! This will get my started!

Regards,
Harmannus