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.

Featured

  • Microsoft Nabs IoT Platform Provider Express Logic

    As part of its plan to invest $5 billion in IoT technologies, Microsoft this week acquired Express Logic, which provides real-time operating systems for industrial embedded and IoT devices.

  • Dealing with Broken Dependencies in SCVMM

    Brien shows you how to resolve some broken, template-related dependencies in Microsoft's System Center Virtual Machine Manager.

  • AzCopy Preview Adds AWS S3 Data Transfer Improvements

    Microsoft announced this week that it has improved the preview version of its AzCopy tool to better handle Amazon Web Services (AWS) S3 data.

  • Microsoft Adding Google G Suite Migration in Exchange Admin Center

    Microsoft's Exchange Admin Center will be getting the ability to move Google G Suite calendar, contacts and e-mail data over to the Office 365 service "in the coming weeks."

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.