I've got a client that wants to use Access as the database for his site. I've talked with him about scaling to SQL Server, but he wants to stay with Access.
The vast majority of asp work I do is with SQL Server or Oracle on the backend. I've done a little work with Access but almost nothing with it and asp, so I'm a little out of my element.
In Access, he's got some reports that are based on queries that are in turn based on his main table. He wants to see these reports on his web site.
My question is twofold:
1) Is there a way in asp to display the reports he has already designed in Access? In other words, do I need to recreate the reports myself or is there some type of Access object I can call in asp and use to display his report on a web page?
2) Is there a way to return the results of an Access query into an asp recordset like I can with a stored procedure in SQL Server?
A wrinkle for both questions: the queries (and therefore the reports) in Access have an input parameter (e.g. county number). Can you address this too in your answers?
I will increase the points for affirmative answers with code samples.