Visual Basic 6.0 and Excel

[tariq123]

Hi,

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:

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?

[RobDog888]

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