Open a different database

[cjany]

I would like an option button on an Access database form to close the current database and open another database. Any suggestions?

 

[rjoubert]

Well, this code doesn't seem to work on my PC, but at least it'll give you a starting point...

    Dim objAccess As Access.Application
    Dim strPath As String

    Set objAccess = CreateObject("Access.Application")
    strPath = "This is the file path to your other DB"

    objAccess.CloseCurrentDatabase
    objAccess.OpenCurrentDatabase strPath, False

 

[PHV]

Have a look to the OpenCurrentDatabase method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886