SSW Access Reporter .NET For IIS
Microsoft Access has always had an excellent report writer, but there
have been serious hurdles to using those reports on the Internet. The
Jet engine really wasn't designed for the sort of heavy pounding that
it can get from web visitors, and Access Data Pages (Microsoft's solution
to displaying Access on the web) are out of step with web standards.
SSW Access Reporter .NET For IIS supplies a new way to move Access reports
to the Internet via .NET code. This utility supplies a report server that
talks directly to the Jet engine, and some objects that you can call from
ASP.NET pages. These objects in turn use .NET remoting to retrieve the
actual reports from the report server.
You can transfer your Access reports to HTML pages, Access snapshots,
or Adobe Acrobat files (assuming you have the right pieces from Adobe,
anyhow). There's no need to modify the source database, but you do have
to tell the Reporter which databases it's allowed to use explicitly. This
helps make sure that you don't accidentally leak insecure information
to the net.
There's an online demo available from the SSW web site at http://www.ssw.com.au/ssw/AccessReporterForIIS/,
and there's a downloadable trial version that you can test on your own
network. If you've got a bunch of Access reports to move to the net, this
one should pay for itself quickly.
[This review originally appeared in developer central 1.9.editor]
Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.