Visual Basic 6.0 and Excel

Hi,:wave:

I seem to be having problems with this code below, I have a Form made using Visual Basic 6.0 and a command button, inside the command button is:

Code:

---

Dim AccessApp As New Access.Application
Set AccessApp = CreateObject ("Access.Application") AccessApp.OpenCurrentDatabase ("C:\music.mdb") AccessApp.Visible = True AccessApp.DoCmd.OpenForm "frmmusic"

---

Now, what I'm trying to do is open a current database from this one command button, the database is stored on C:\ called music.mdb this seems to work but the problem i seem to be having is once Microsoft Access opens.. it closes straight away, any suggestions on how I can resolve this problem?

See my reply in you other thread in the Classic VB forum.