open another database from current

[SIN]

I have the following code, I want to open "C:\Users\MKOSCICA\Documents\My Documents\DKN\Stanovništvo_2016\Stanovništvo_2016-05\Retail portfolio 2016 05.accdb", but it is not visible, what to do?

Thanks!


Dim NewAccessApp As Access.Application
'Set NewAccessApp = CreateObject("Access.Application")
Set NewAccessApp = New Access.Application
With NewAccessApp
.OpenCurrentDatabase "C:\Users\MKOSCICA\Documents\My Documents\DKN\Stanovništvo_2016\Stanovništvo_2016-05\Retail portfolio 2016 05.accdb"
.Visible = True

 

[Minty]

Have a look at this thread for some possible clues http://www.access-programmers.co.uk/forums/showthread.php?t=287193