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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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
zacharCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dfhainesAuthor Commented:
Thanks for your emails.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.