I have a database created with MS Access 2003 which contains a large number of reports. These reports are generated based on queries and, while using Access, the parameters for these queries are gathered in a form. Internally (i.e. when opening the mdb in Access) all of the operations work perfectly.
However, I now need to be able to collect those parameters (like date ranges) from an ASP page and publish the Access report to the browser.
In order to bridge the native process to web application gap, the ASP application implements a WCF client and the server sits on a machine with the database. When the ASP client requests a report, I need the server to be able to programmatically supply those parameters to MS Access, generate the report, save it to HTML, then return the HTML to the client.
My current implementation/attempt using the Microsoft.Office.Interop.A
ccess library to get a handle to the Access object and from there I can
but that doesn't allow me to supply parameters. I can also
oAccess.Run("Procedure1", "Parameter1", "Parameter2")
but that still leaves me with having to do all of the query work in VBA.
Thanks for you time,