I open an Access project via a VB6 app like so:
Dim appAccess As Object
Set appAccess = CreateObject("Access.Application")
appAccess.Visible = True
When I close a particular form, the Access database exits. This doesn't happen with all forms and there is a hidden form always open so it's not like it's the last form being closed.
This form isn't bound to a table or anything, rather it's just an unbound text box and a button, the form has no events on_close, it has no event handlers preiod.
-This doesn't happen if I open the project without the VB app. (ie. double click it in Windows Explorer)
-I found no difference if I kept the VB app open or closed during the Access project lifespan
Does anyone know why this is happenning?