'After your lines of code that open the other database,
Application.CloseCurrentDatabase

~J

I have 3 databases and I would like to move from one database to another
without closing access. I have been able to do so with 2 of my databses but
not with the third. I have ctrated buttons on my main page. when you click
one database closes and another one opens. Below is the code I used in VBA to
create the button to work. One works and the other does not.
If you have any other suggestions great.
Please help.
This one does not work.
Private Sub cmdGoToVelocityDatabase_Click()

   Dim app As Access.Application
   Set app = New Access.Application
   app.OpenCurrentDatabase "S:\Product Info\Velocity\Velocity.mdb"
   app.Visible = True
   DoCmd.Close acForm, "frmMain"
End Sub

This one does work.
Private Sub cmdGoToGiftCardDatabase_Click()

   Dim app As Access.Application
   Set app = New Access.Application
   app.OpenCurrentDatabase "S:\Database\Gift Cards.mdb"
   app.Visible = True
   DoCmd.Close acForm, "frmMain"
End Sub
I also have a macro that exits access on the button.