Product Reviews

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

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

comments powered by Disqus

Reader Comments:

Add Your Comment Now:

Your Name:(optional)
Your Email:(optional)
Your Location:(optional)
Comment:
Please type the letters/numbers you see above

Redmond Tech Watch

Sign up for our newsletter.

I agree to this site's Privacy Policy.