Solved

Calling a Microsoft Access Report from Java

Posted on 2003-11-30
8
652 Views
Last Modified: 2007-12-19
Anyone got any ideas or sites where I can try to find out how to call a Microsoft Access Report from a Java application?
0
Comment
Question by:imnotahomey
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 92

Expert Comment

by:objects
ID: 9848047
think you're only option would be to start Access using Runtime.exec()
0
 

Author Comment

by:imnotahomey
ID: 9848213
I need to pass parameters to the access report from my Java program. I would prefer not having to redo the entire report in another reporting tool.
0
 
LVL 92

Accepted Solution

by:
objects earned 350 total points
ID: 9848222
Perhaps ask in the Access topic what command line you need to use to display your report. Then use Runtime.exec() to execute it.
0
 
LVL 15

Expert Comment

by:dualsoul
ID: 9848632
hm...i suggest you to create dll in C++ or VB which is do everything you want with MS Access through COM model.
   Then use JNI mechanism to call dll functions from Java and pass parameters to it.

   Read JNI tutorial at java.sun.com to understand JNI
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Expert Comment

by:sre23
ID: 9853435
create a shortcut to the report from access (this creates a shortcut file with a .mar extension I belive.  Then use Runtime.exec() and open that shortcut.  Then you open your report directly :)
0
 
LVL 1

Expert Comment

by:sre23
ID: 9853588
>>I need to pass parameters to the access report from my Java program.

I don't think you can pass info directly, but there is a way to do it.  Configure your report to pull whatever info you need from a table and use jdbc to pass info from your java app to your Access database.  Just use an Insert query.  If you need further explanation let me know.  I have been in this same predicament before.

After you have updated the table with the appropraite info, here is the command you can use to open the report (This worked for me with Access 2000 on a Windows XP machine)

Runtime load = Runtime.getRuntime();        
//open the file
load.exec("\"C:\\Program Files\\Microsoft Office\\Office\\MSACCESS.EXE\" /NOSTARTUP /SHELLSYSTEM [OpenReport \"C:\\Report.mar\",2]\"");

It looks confusing but basically this is the command your pc uses when you click on the report shortcut.
0
 

Author Comment

by:imnotahomey
ID: 9855234
Thanks everyone for your help.
I found some answers in the Access topic thanks to objects
I will probably end up running the following command line that i got from Mr TextReport, which made me happy
------------------------
"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" /x MacroName /CMD "[MyField]=5"

Function PrintReport
     docmd.openreport "MyReport", , Command$
End Function

and the macro does a runcode PrintReport()
-------------------------
Boog.
0
 
LVL 92

Expert Comment

by:objects
ID: 9855290
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
My project did see openJDK that I installed. What could be the problem 7 121
Java and GPO 11 66
Image decoding from Camera 3 72
Java Loop 6 48
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
The viewer will learn how to implement Singleton Design Pattern in Java.
This video teaches viewers about errors in exception handling.

919 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

12 Experts available now in Live!

Get 1:1 Help Now