Start mdb from mdb

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

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
 
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
 
Back
Top