Call another access database from inside an access database

When inside an access database, I would like call another access database and close the current one.

How can I do that please?

snyperjAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:


sub openotherdb()
dim acObj as object
set acObj=createObject("access.application")
     acObj=opencurrentdatabase(<path to the other db>)
     acObj.usercontrol=true
docmd.quit

end sub
0
All Courses

From novice to tech pro — start learning today.