Link to home
Start Free TrialLog in
Avatar of ca1358
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.Application")

 
 Call appAccess.OpenCurrentDatabase( _
 "\\DTCHYB-ILSP001\C_MTG_Groups\Mandatory\Analysts - Working Files\Carol\Test\Expert\TestAccess.mdb")
   appAccess.Visible = True
End Sub
ASKER CERTIFIED SOLUTION
Avatar of Anders Ebro (Microsoft MVP)
Anders Ebro (Microsoft MVP)
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial