Can anyone help me?

The problem I am having is I need to be in a database, have the user select
another database using an ActiveX explorer control, then using code, close
the current database and open the selected one without opening another
instance of Access.

Please E-mail and post the response.

Hi Vito,

AFAIK., to open a database within the same instance of Access, you need to
use Sendkeys, something we don't advice normally.

The syntax would be
SendKeys "%FO" & strInMDB & "~"

where strInMDB is the path to the mdb you've selected.

But unless you're bound to using the same instance, I'd suggest using
Automation (CreateObject) to spawn another instance of Access and then use
OpenCurrentDatabase on this new instance.

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:Can anyone help me?
:
:The problem I am having is I need to be in a database, have the user select
:another database using an ActiveX explorer control, then using code, close
:the current database and open the selected one without opening another
:instance of Access.
:
:Please E-mail and post the response.
:

:
:

Would this work for you:
Shell("MSACCESS.EXE " & YourDataBase);
Docmd.Quit

It starts a new instance and closes the current one. There's a gotcha: you
must know the access program path.

Vito a crit dans le message ...