Dim accessApp As Access.Application = CreateObject("Access.Application")accessApp.OpenCurrentDatabase("path to your access file"", True)accessApp.visible = TrueaccessApp.DoCmd.OpenReport("your report name", Access.AcView.acViewPreview)accessApp.Quit()
You would need to either use OLE automation or create a macro that prints the report and then closes the database. You could then just shell out to run Access with the macro name as an argument.
Open in new window