Trouble opening a new instance of Access

carlnewton

Registered User.
Local time
Today, 13:12
Joined
Jan 10, 2008
Messages
19
I'm simply trying to open a new instance of Access with the following code:

Dim objAccess as object
Dim stTarget as string

stTarget = "<DB PATH>"

Set objAccess = CreateObject("Access.Application")
With objAccess
.OpenCurrentDatabase stTarget
.Visible = True
End With
Set objAccess = Nothing

When executed, the new instance of Access has no menus. The logon form (PopUP) that is started via the 'Startup' option opens, and when I logon the following Switchboard form is invisible. Any ideas?

Thanks in advance.
 

Users who are viewing this thread

Back
Top Bottom