>>Is it possible to run a MS Access report from a VB 5.0 program. Currently wee attach FoxPro tables to a MDB file and we have some stored queries in the MDB file as well. We want to replace our current Report Write software and one possiblity is having saved reports in the MDB that VB can call.
>
>VideoSoft makes a product called VSReports that can run Access reports. You might check with them. Outside of a 3rd party control like that, you could only do it through OLE.
Reports, Forms & Modules inside an MDB files are not DAO objects. They are Access objects that can be accessed only by Access.
You can use them by Automation but your users will need a copy of Access installed.
Videosoft is misleading developers in it's ads for VSReports.
The product will read an already created report in an Access database. Save the report in it's own format. At runtime, you never access the report in the MDB file.
So it's recreating the reports.
I wanted to let my users create and modify reports but, no luck.