Pulling Access Reports into VB.Net

Posted on 2007-08-09
Last Modified: 2010-04-23
Hi all,
My app has an Access database in the background. Is there any way I can pull Access reports into my VB.Net app so users can view and print the reports without going directly into Access?
If not it there a piece of software available that I can make use of that allows users to create and print reports using Access data in VB.Net?
Many Thanks
Question by:kiranboi
    LVL 14

    Expert Comment

    You can simply connect to the Access database and return a dataset.  Then you can display the data any way you wish...

    Here are some Access connection strings...
    LVL 28

    Accepted Solution

    Public Sub RunReport(ByVal sReport As String)
            Dim oAccess As Object
            Dim sDB As String = DBPATH

            oAccess = CreateObject("Access.Application")

            ' Open the database
            oAccess.DoCmd.OpenReport(sReport, 2) ' 2 for preview; no second argument - for printing
            oAccess.Visible = True
        End Sub

    Author Comment

    Just what I needed. Thanks :)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
    If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
    This video discusses moving either the default database or any database to a new volume.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now