Skip to Content

Cannot Connect CR 2011 to MS Access 2016

Hello,

It looks like this issue was brought up in this thread.

https://answers.sap.com/questions/43890/cannot-connect-accdb-file-running-in-access-2016-t.html

I am running Office 2016 on Windows 7 and I have Crystal Reports 2011. I'm not able to connect to my Access 2016 database.

One suggestion in this prior forum was:

"You could try adding a 32 bit ODBC connection but I doubt that will show the old Access MDB driver."

How do I do this?

MS suggests a workaround as well but I don't know how exactly to do this either?

"To work around this problem, use the appropriate version of the ODBC Administrator tool. If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe. To indicate the type of DSN, you can add "_32" to the 32-bit user DSNs and "_64" to the 64-bit user DSNs."

Thank you in advance for any help. -Rich

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 28, 2017 at 03:08 PM

    as the MS suggestion says - you run %windir%\SysWOW64\odbcad32.exe and then create DSN to your access DB with name that has _32 in it (to make it easy to recognize).

    For Crystal you need 32 bit DSN. that's how you make it.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 28, 2017 at 03:34 PM

    Thanks so much for the response. The problem is that I don't know how to do this. Can someone walk me through the steps exactly on how to perform this? Thank you again

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 28, 2017 at 06:14 PM

    So as it turns out, I do have Office 32 bit installed on my machine. However CR 2011 is still not recognizing Access 2016. What is the workaround?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2017 at 04:29 PM

    Hi Rich,

    If you go to the Windows Start button and select Run, type or copy and paste:

    %windir%\SysWOW64\odbcad32.exe

    This should open the 32 Bit ODBC administrator.

    Go to the System DSN tab and press the Add button.

    In the Create New Datasource window, select Microsoft Access Driver (*.mbd, *.accdb). Be careful you select the correct one. Others in the list are for different languages and older versions of Access.

    Now you can give your Datasource a name, usually the name of the database is best.

    Select your database and if it's secured, you can select the System Database and enter the password. Most of the time you shouldn't have to select the System database, which would be an .MDW file.

    Now you should be able to go into Crystal and using ODBC, connect to you database.

    Hope this helps,

    Brian

    Add comment
    10|10000 characters needed characters exceeded