In general not a good idea unless you approach it like I do with this
product.
http://www.rptsoftware.com/products/reportserver/
It basically runs one instance of Access on the server and uses a COM
component and lots of error checking to
handle the report requests. Note: the product hasn't been updated to work
with access 2007 or 2010 (you would need to tweak source code).
Low end reporting tools include:
- this product to run access reports
- active reports
- crystal reports (if they still have a low end version)?
- probably a few others
High end products
- sql server reporting services
- business objects
- cognos
- oracle reports
- many others
If you have the budget make the plunge to reporting services.
low end I would go with report server or active reports.
If there are not too many report parameters or if batch reporting worked as
a solution you could crank out a bunch of reports as pdf files and then get
them on your sharepoint site.
There are some listview controls that can pull data from many sharepoint
lists and do something close to reporting (another approach).
Just my opinion,
Been doing access based web reporting for about 10 years now,
Mark
