ca1358
asked on
Stop Access Database from Closing
Excel open Access Database
When run the Macro it opens the Access Database but goes to End Sub and close it. How do I stop the Code from End Sub so it does not close the Database
Code:
Sub Macro4()
' open database
Dim appAccess As Object
Set appAccess = CreateObject("Access.Appli cation")
Call appAccess.OpenCurrentDatab ase( _
"\\DTCHYB-ILSP001\C_MTG_Gr oups\Manda tory\Analy sts - Working Files\Carol\Test\Expert\Te stAccess.m db")
appAccess.Visible = True
End Sub
When run the Macro it opens the Access Database but goes to End Sub and close it. How do I stop the Code from End Sub so it does not close the Database
Code:
Sub Macro4()
' open database
Dim appAccess As Object
Set appAccess = CreateObject("Access.Appli
Call appAccess.OpenCurrentDatab
"\\DTCHYB-ILSP001\C_MTG_Gr
appAccess.Visible = True
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.