[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

Pulling Access Reports into VB.Net

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
0
kiranboi
Asked:
kiranboi
1 Solution
 
NBSO_ISSCommented:
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...

http://www.sqlstrings.com/MS-Access-connection-strings.htm
0
 
iboutchkineCommented:
Public Sub RunReport(ByVal sReport As String)
        Dim oAccess As Object
        Dim sDB As String = DBPATH

        oAccess = CreateObject("Access.Application")

        ' Open the database
        oAccess.OpenCurrentDatabase(sDB)
        oAccess.DoCmd.OpenReport(sReport, 2) ' 2 for preview; no second argument - for printing
        oAccess.DoCmd.Maximize()
        oAccess.Visible = True
    End Sub
0
 
kiranboiAuthor Commented:
Just what I needed. Thanks :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now