I am trying to launch an access 97 database (.mdb) from an Excel 97 spreadsheet, using the following code attached to a button:
Dim oAccApp As Object
Set oAccApp = CreateObject("Access.Application")
oAccApp.Application.Visible = True
oAccApp.Application.OpenCurrentDatabase "<PATH HERE>\database.mdb"
It's working fine except for one thing: access is loading up the database but only for a split second then instantly disappearing again. I know this is probably really obvious but can anyone help me?