MS Access


Can I use SQL Server Reporting Services with an Access Database?
Yes, there are a number of ways to use SQL Server Reporting Services (SSRS) with Access databases. As background, SQL Server allows for the importing of Access database reports into SQL Server Reporting Services. This provides the advantage of building Access reports initially and then migrating those same Access reports to SSRS later without having to reproduce the reports. SSRS provides additional features above and beyond Access database reporting including the ability to view reports via an Internet browser, report subscriptions, and many other features.