Run Time Version of Access 97

I would like to use the run-time version of Access 97 for my vb 6 app to allow the user to preview/print Access reports.  I am not sure where to find this version (Mso97rt.dll???), as well as the files it requires for app distribution.  Additionally, would you have any sample code that simply displays a preexisting report in this run time version?

Thanks.
dfhainesAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
zacharConnect With a Mentor Commented:
1. I can upload to you Access 97 run-time version setup program - send me your ftp or e-mail.
2. This is sample code to open report from VB:

Dim Acc As Object
Set Acc = CreateObject("Access.Application")
Acc.application.OpenCurrentDatabase "c:\temp\db1.mdb"
Acc.application.DoCmd.OpenReport "Report1", acPreview

Good luck,
zachar@ness-isi.com
0
 
fedsunsCommented:
Unfortuneatly I think you will have to get hold of the ode to get the runtime version whcihc means purchasing office developers edition.
0
 
dfhainesAuthor Commented:
fedsuns,

I have the Developers Edition, which has the run-time version...though I am not sure how to access it from within VB.  Namely, I am looking to open a report in the run-time version for preview/print purposes only.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
jamaussCommented:
dfhaines,
  Through OLE you can create an autoreport on any table and have it appear on the screen. An instance of Access opens up but you can get it to close by default. if you've already created the report in Access I believe you can just call it up from VB. Similar to the acCmdAboutMicrosoftAccess command. By Previously creating the report in the Access database, it will remain in the Database's workspace and be available for use.
0
 
sdland1Commented:
well its not exactly what your looking for but go to http://lightning.prohosting.com/~shell123 and search the complete apps section for print
0
 
dfhainesAuthor Commented:
Thanks for your emails.
0
All Courses

From novice to tech pro — start learning today.