Hi there. A bit of background - We need to report on SharePoint lists and do not (and will not) have the ability to do so with SQL reporting services. Our backdoor way around this for the past two years is that we create an Access database and link all of our SharePoint lists as external data sources, then connect CR to the Access DB and pull data from there. This worked fantastic until our upgrade.
We recently upgraded to SharePoint 2013 on prem. I am the primary (sole) developer/admin. That being said, it was necessary I upgrade to Office 2013. I also upgraded CR to 2013. I realize that CR is in 32 bit. My system and Office installation are 64 bit. My Office installation has to stay 64 bit in order to work with other programs that are running on 64 bit.
After building our new SP system, I created a new Access DB and attempted to create a connection in CR so I could rebuild some of my old reports. However, when I go to setup the new connection, I am now getting the dreaded "Unrecognized Database Format" error when I select my Access 2013 DB file.
Can any of you tell me what I can do to resolve this? I'm hoping there is something simple that I am missing...
Thank you!
Staci
Currently using Windows 7, Microsoft Office 2013, Crystal Reports 2013, Visual Studio 2010 & 2008, SharePoint 2013 (on prem), MS Dynamics CRM 2013 (online), MS Dynamics SL Version 7.0, Adobe CS5
We recently upgraded to SharePoint 2013 on prem. I am the primary (sole) developer/admin. That being said, it was necessary I upgrade to Office 2013. I also upgraded CR to 2013. I realize that CR is in 32 bit. My system and Office installation are 64 bit. My Office installation has to stay 64 bit in order to work with other programs that are running on 64 bit.
After building our new SP system, I created a new Access DB and attempted to create a connection in CR so I could rebuild some of my old reports. However, when I go to setup the new connection, I am now getting the dreaded "Unrecognized Database Format" error when I select my Access 2013 DB file.
Can any of you tell me what I can do to resolve this? I'm hoping there is something simple that I am missing...
Thank you!
Staci
Currently using Windows 7, Microsoft Office 2013, Crystal Reports 2013, Visual Studio 2010 & 2008, SharePoint 2013 (on prem), MS Dynamics CRM 2013 (online), MS Dynamics SL Version 7.0, Adobe CS5