SSRS 64bit - Connect to Microsoft Access

Posted on 2014-07-16
Last Modified: 2014-07-17

I have created a SSRS report that connects to an access database using the following OLE DB connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="\\Folder\Database.accdb"

The report works like a charm when using the development studio (MS Visual Studio) but it does not connect once deployed. I get the following error message:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DateSource'. (rsErrorOpeningConnection)
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

We have 64bit SSRS installed on a 64bit 2008 ms server. I only have the 32bit drivers for access, which I am guessing is the problem. Are the 64bit access drivers available?

Thanks, Greg
Question by:spen_lang
    1 Comment
    LVL 56

    Accepted Solution

    You can get the 64bit drivers here:


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now