That will indeed launch Access, but I won't get back an object handle so that I can perform other actions on it. Once it's launched, I could find it via GetObject, but I would think there'd be a more direct way via CreateObject.
I'm trying to launch Access from VB for report printing. This much works OK.<br>
<br>
Set ObjAccess = CreateObject("Access.Application")<br>
With ObjAccess<br>
.Visible = True<br>
.OpenCurrentDatabase (MyPath & MyDbname)<br>
RptName = "Whatever"<br>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.