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 Publishes Windows Deadlines on Upgrading to SHA-2

    Microsoft on Friday described its 2019 timeline for when it will start distrusting Shell Hashing Algorithm-1 (SHA-1) in supported Windows systems, as well as in the Windows Server Update Services 3.0 Service Pack 2 management product.

  • Performing a Storage Refresh on Windows Server 2016, Part 1

    To spruce up some aging lab hardware, Brien decided to make the jump to all-flash storage. Here's a walk-through of the first half of the process.

  • Datacenters Are Cooling Down as Buildouts Heat Up

    Tech giants Google, Apple and others are expanding their datacenter footprints at a rapid rate, and it's pushing the industry to find better ways to power all that infrastructure.

  • Vendors Issue Patches for Linux Container Runtime Flaw Enabling Host Attacks

    This week, the National Institute of Standards and Technology (NIST) described a high-risk security vulnerability (CVE-2019-5736) for organizations using containers that could lead to compromised host systems.

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.